APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 821: from pay_personal_payment_methods_f pppm /*added newly to fix bug#2133040 */

817: rtrim(substrb(pea.segment5,1,150))))
818: /*Per'l Payment Method Bank_number for CA, Bank Name for US */
819: ,pea.segment4 /* Per'l Payment Method Transit_code */
820: ,pea.segment3 /* Per'l Payment Method Account_Number */
821: from pay_personal_payment_methods_f pppm /*added newly to fix bug#2133040 */
822: ,pay_external_accounts pea
823: where pppm.personal_payment_method_id = cp_personal_paymeth_id
824: and cp_effective_date between pppm.effective_start_date and
825: pppm.effective_end_date /* BUG: 5383895 cp_date_earned changed to cp_effective_date */

Line 895: from pay_personal_payment_methods_f pppm

891: cursor c_tp_payee_info (cp_personal_paymeth_id number
892: default NULL,
893: cp_effective_date date) IS /* BUG: 5383895 cp_date_earned changed to cp_effective_date */
894: select pppm.payee_type,pppm.payee_id
895: from pay_personal_payment_methods_f pppm
896: where pppm.personal_payment_method_id = cp_personal_paymeth_id
897: and cp_effective_date between pppm.effective_start_date and
898: pppm.effective_end_date; /* BUG: 5383895 cp_date_earned changed to cp_effective_date */
899: