DBA Data[Home] [Help]

APPS.PAY_US_DEPOSIT_ADVICE_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 836: pay_personal_payment_methods_f pppm

832: cursor c_payments (cp_pre_pymt_action_id in number,
833: cp_effective_date in date) is
834: select distinct ppp.source_action_id
835: from pay_pre_payments ppp,
836: pay_personal_payment_methods_f pppm
837: where ppp.assignment_action_id = cp_pre_pymt_action_id
838: and pppm.personal_payment_method_id = ppp.personal_payment_method_id
839: and pppm.external_account_id is not null
840: and cp_effective_date between pppm.effective_start_date