APPS.FV_CCR_UTIL_PVT dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 102: x_payee_id OUT NOCOPY iby_external_payees_all.ext_payee_id%TYPE

98: /* Procedure to get the payee id for the supplier site */
99: procedure get_payee_id
100: (
101: p_payee_context IN IBY_DISBURSEMENT_SETUP_PUB.PayeeContext_rec_type,
102: x_payee_id OUT NOCOPY iby_external_payees_all.ext_payee_id%TYPE
103: )
104: IS
105: CURSOR c_payee
106: (ci_party_id IN p_payee_context.Party_Id%TYPE,

Line 114: FROM iby_external_payees_all payee

110: ci_org_id IN p_payee_context.Org_Id%TYPE,
111: ci_pmt_function IN p_payee_context.Payment_Function%TYPE)
112: IS
113: SELECT ext_payee_id
114: FROM iby_external_payees_all payee
115: WHERE payee.PAYEE_PARTY_ID = ci_party_id
116: AND payee.PAYMENT_FUNCTION = ci_pmt_function
117: AND ((ci_party_site_id is NULL and payee.PARTY_SITE_ID is NULL) OR
118: (payee.PARTY_SITE_ID = ci_party_site_id))

Line 1490: update iby_external_payees_all

1486:
1487: /*Inactivating the external payee account created using this old supplier site*/
1488: Begin
1489:
1490: update iby_external_payees_all
1491: set inactive_date=sysdate
1492: where supplier_site_id=l_ss_vendor_site_id
1493: AND org_id = p_org_id;
1494: exception

Line 1504: (select distinct ext_payee_id from iby_external_payees_all

1500: Begin
1501: update iby_pmt_instr_uses_all
1502: set end_date=sysdate
1503: where ext_pmt_party_id in
1504: (select distinct ext_payee_id from iby_external_payees_all
1505: where supplier_site_id=l_ss_vendor_site_id
1506: and org_id = p_org_id);
1507:
1508: exception