BIP Report Parameter options

 Reusable logics for report parameters

All option with multiple value selection in BIP Reports 

  and ((coalesce (null,:p_Period_Name) is null)

                          or (xah.Period_Name in(:p_Period_Name))

                          or 'ALL' in(:p_Period_Name)

  )

 and((coalesce (null,:p_ledger_Name) is null)

                          or (Gl.Name in(:p_ledger_Name))

                          or 'ALL' in(:p_ledger_Name)

  )

 and ((coalesce (null,:p_Segment1) is null)

                          or (Cde.Segment1 in(:p_Segment1))

                          or 'ALL' in(:p_Segment1)