APPS.PAY_CA_PAYREG_EXTRACT_PKG dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

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

800: rtrim(substrb(pea.segment5,1,150))))
801: /*Per'l Payment Method Bank_number for CA, Bank Name for US */
802: ,pea.segment4 /* Per'l Payment Method Transit_code */
803: ,pea.segment3 /* Per'l Payment Method Account_Number */
804: from pay_personal_payment_methods_f pppm /*added newly to fix bug#2133040 */
805: ,pay_external_accounts pea
806: where pppm.personal_payment_method_id = cp_personal_paymeth_id
807: and cp_effective_date between pppm.effective_start_date and
808: pppm.effective_end_date /* BUG: 5383895 cp_date_earned changed to cp_effective_date */

Line 878: from pay_personal_payment_methods_f pppm

874: cursor c_tp_payee_info (cp_personal_paymeth_id number
875: default NULL,
876: cp_effective_date date) IS /* BUG: 5383895 cp_date_earned changed to cp_effective_date */
877: select pppm.payee_type,pppm.payee_id
878: from pay_personal_payment_methods_f pppm
879: where pppm.personal_payment_method_id = cp_personal_paymeth_id
880: and cp_effective_date between pppm.effective_start_date and
881: pppm.effective_end_date; /* BUG: 5383895 cp_date_earned changed to cp_effective_date */
882: