DBA Data[Home] [Help]

APPS.JA_CN_AP_VALIDATION_PKG dependencies on XLE_ENTITY_PROFILES

Line 326: FROM Xle_Entity_Profiles xep

322: CURSOR legal_entity_cur
323: (lv_bal_seg_value NUMBER)
324: IS
325: SELECT xep.Name Legal_Entity
326: FROM Xle_Entity_Profiles xep
327: ,Gl_Ledger_Norm_Seg_Vals glnsv
328: WHERE glnsv.ledger_id = pn_ledger_id --parameter: pn_ledger_id
329: AND glnsv.legal_entity_id = xep.legal_entity_id
330: AND glnsv.Segment_Value = lv_bal_seg_value --variable: lv_bal_seg_value

Line 399: FROM XLE_ENTITY_PROFILES

395: L_XML_REPORT := NULL;
396: --get legal entity name
397: SELECT name
398: INTO lv_le_name
399: FROM XLE_ENTITY_PROFILES
400: WHERE legal_entity_id=pn_legal_entity_id;
401:
402: --get ledger name
403: SELECT name