APPS.FV_CCR_UTIL_PVT dependencies on IBY_EXTERNAL_PAYEES_ALL

Line 99: x_payee_id OUT NOCOPY iby_external_payees_all.ext_payee_id%TYPE

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

Line 111: FROM iby_external_payees_all payee

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