APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 116: FROM XLE_FIRSTPARTY_INFORMATION_V xle

112:
113: CURSOR payer_country_csr(p_payer_le_id NUMBER)
114: IS
115: SELECT xle.country
116: FROM XLE_FIRSTPARTY_INFORMATION_V xle
117: WHERE xle.legal_entity_id = p_payer_le_id;
118:
119: BEGIN
120:

Line 709: FROM XLE_FIRSTPARTY_INFORMATION_V xlev,

705: CURSOR payer_info_csr(p_payer_le_id IN NUMBER)
706: IS
707: SELECT xlev.country,
708: glv.currency_code
709: FROM XLE_FIRSTPARTY_INFORMATION_V xlev,
710: GL_LEDGER_LE_V glv
711: WHERE xlev.legal_entity_id = glv.legal_entity_id
712: AND glv.ledger_category_code = 'PRIMARY'
713: AND xlev.legal_entity_id = p_payer_le_id;

Line 1729: FROM XLE_FIRSTPARTY_INFORMATION_V xle

1725:
1726: CURSOR payer_country_csr(p_payer_le_id NUMBER)
1727: IS
1728: SELECT xle.country
1729: FROM XLE_FIRSTPARTY_INFORMATION_V xle
1730: WHERE xle.legal_entity_id = p_payer_le_id;
1731:
1732: BEGIN
1733: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3176: FROM XLE_FIRSTPARTY_INFORMATION_V xlev,

3172: CURSOR payer_info_csr(p_le_id IN NUMBER)
3173: IS
3174: SELECT xlev.country,
3175: glv.currency_code
3176: FROM XLE_FIRSTPARTY_INFORMATION_V xlev,
3177: GL_LEDGER_LE_V glv
3178: WHERE xlev.legal_entity_id = glv.legal_entity_id
3179: AND glv.ledger_category_code = 'PRIMARY'
3180: AND xlev.legal_entity_id = p_le_id;