APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 86: FROM XLE_FIRSTPARTY_INFORMATION_V xle

82:
83: CURSOR payer_country_csr(p_payer_le_id NUMBER)
84: IS
85: SELECT xle.country
86: FROM XLE_FIRSTPARTY_INFORMATION_V xle
87: WHERE xle.legal_entity_id = p_payer_le_id;
88:
89: BEGIN
90:

Line 628: FROM XLE_FIRSTPARTY_INFORMATION_V xlev,

624: CURSOR payer_info_csr(p_payer_le_id IN NUMBER)
625: IS
626: SELECT xlev.country,
627: glv.currency_code
628: FROM XLE_FIRSTPARTY_INFORMATION_V xlev,
629: GL_LEDGER_LE_V glv
630: WHERE xlev.legal_entity_id = glv.legal_entity_id
631: AND glv.ledger_category_code = 'PRIMARY'
632: AND xlev.legal_entity_id = p_payer_le_id;

Line 1548: FROM XLE_FIRSTPARTY_INFORMATION_V xle

1544:
1545: CURSOR payer_country_csr(p_payer_le_id NUMBER)
1546: IS
1547: SELECT xle.country
1548: FROM XLE_FIRSTPARTY_INFORMATION_V xle
1549: WHERE xle.legal_entity_id = p_payer_le_id;
1550:
1551: BEGIN
1552: print_debuginfo(l_module_name,'ENTER');

Line 2816: FROM XLE_FIRSTPARTY_INFORMATION_V xlev,

2812: CURSOR payer_info_csr(p_le_id IN NUMBER)
2813: IS
2814: SELECT xlev.country,
2815: glv.currency_code
2816: FROM XLE_FIRSTPARTY_INFORMATION_V xlev,
2817: GL_LEDGER_LE_V glv
2818: WHERE xlev.legal_entity_id = glv.legal_entity_id
2819: AND glv.ledger_category_code = 'PRIMARY'
2820: AND xlev.legal_entity_id = p_le_id;