DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on IBY_EXT_PAYEE_RELATIONSHIPS

Line 3751: FROM iby_ext_payee_relationships irel

3747: l_supplier_site_id IN NUMBER,
3748: l_remit_party_id IN NUMBER,
3749: l_remit_supplier_site_id IN NUMBER) IS
3750: SELECT irel.additional_information
3751: FROM iby_ext_payee_relationships irel
3752: WHERE irel.party_id = l_party_id
3753: AND irel.supplier_site_id = l_supplier_site_id
3754: AND irel.remit_party_id = l_remit_party_id
3755: AND irel.remit_supplier_site_id = l_remit_supplier_site_id

Line 3803: FROM iby_ext_payee_relationships irel

3799: l_supplier_site_id IN NUMBER,
3800: l_remit_party_id IN NUMBER,
3801: l_remit_supplier_site_id IN NUMBER) IS
3802: SELECT irel.relationship_id
3803: FROM iby_ext_payee_relationships irel
3804: WHERE irel.party_id = l_party_id
3805: AND irel.supplier_site_id = l_supplier_site_id
3806: AND irel.remit_party_id = l_remit_party_id
3807: AND irel.remit_supplier_site_id = l_remit_supplier_site_id