DBA Data[Home] [Help]

APPS.JA_CN_AR_VALIDATION_PKG dependencies on XLE_ENTITY_PROFILES

Line 203: FROM Xle_Entity_Profiles xep

199: CURSOR legal_entity_cur
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

Line 330: FROM XLE_ENTITY_PROFILES

326: L_XML_REPORT := NULL;
327: --get legal entity name
328: SELECT name
329: INTO lv_le_name
330: FROM XLE_ENTITY_PROFILES
331: WHERE legal_entity_id = pn_legal_entity_id;
332:
333: --get ledger name
334: SELECT name