DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_EXT_PAYEE_RELATIONSHIPS

Line 2746: FROM iby_ext_payee_relationships irel

2742: l_supplier_site_id IN NUMBER,
2743: l_remit_party_id IN NUMBER,
2744: l_remit_supplier_site_id IN NUMBER) IS
2745: SELECT irel.additional_information
2746: FROM iby_ext_payee_relationships irel
2747: WHERE irel.party_id = l_party_id
2748: AND irel.supplier_site_id = l_supplier_site_id
2749: AND irel.remit_party_id = l_remit_party_id
2750: AND irel.remit_supplier_site_id = l_remit_supplier_site_id

Line 2798: FROM iby_ext_payee_relationships irel

2794: l_supplier_site_id IN NUMBER,
2795: l_remit_party_id IN NUMBER,
2796: l_remit_supplier_site_id IN NUMBER) IS
2797: SELECT irel.relationship_id
2798: FROM iby_ext_payee_relationships irel
2799: WHERE irel.party_id = l_party_id
2800: AND irel.supplier_site_id = l_supplier_site_id
2801: AND irel.remit_party_id = l_remit_party_id
2802: AND irel.remit_supplier_site_id = l_remit_supplier_site_id