DBA Data[Home] [Help]

APPS.JA_CN_AR_VALIDATION_PKG dependencies on GL_LEDGER_NORM_SEG_VALS

Line 204: ,Gl_Ledger_Norm_Seg_Vals glnsv

200: (lv_bal_seg_value NUMBER)
201: IS
202: SELECT xep.Name Legal_Entity
203: FROM Xle_Entity_Profiles xep
204: ,Gl_Ledger_Norm_Seg_Vals glnsv
205: WHERE glnsv.ledger_id = pn_ledger_id --parameter: pn_ledger_id
206: AND glnsv.legal_entity_id = xep.legal_entity_id
207: AND glnsv.Segment_Value = lv_bal_seg_value --variable: lv_bal_seg_value
208: AND glnsv.Segment_Type_Code = 'B'