DBA Data[Home] [Help]

APPS.PAY_DK_ARCHIVE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1617: FROM pay_personal_payment_methods_f ppm

1613: ------------
1614: /* Cursor to check if bank details are attached with ppm */
1615: CURSOR csr_chk_bank(p_ppm_id NUMBER) IS
1616: SELECT ppm.external_account_id
1617: FROM pay_personal_payment_methods_f ppm
1618: WHERE ppm.personal_payment_method_id = p_ppm_id
1619: AND p_date_earned BETWEEN ppm.effective_start_date AND ppm.effective_end_date;
1620: -------------
1621: /* Cursor to retrieve Organization Payment Method Information */

Line 1654: pay_personal_payment_methods_f ppm,

1650: ppttl.payment_type_name pay_type,
1651: ppp.value value
1652: FROM pay_external_accounts pea,
1653: pay_org_payment_methods_f pop,
1654: pay_personal_payment_methods_f ppm,
1655: pay_assignment_actions paa,
1656: pay_payment_types ppt,
1657: pay_payment_types_tl ppttl,
1658: pay_pre_payments ppp