DBA Data[Home] [Help]

APPS.PAY_AE_SI_REPORTS dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1337: FROM pay_personal_payment_methods_f

1333:
1334: /* Cursor for fetching External account id and org payment method id*/
1335: CURSOR csr_get_ext_id_org_paymeth (l_assignment_id number,l_effective_date date) IS
1336: SELECT external_account_id,org_payment_method_id
1337: FROM pay_personal_payment_methods_f
1338: WHERE assignment_id = l_assignment_id
1339: AND l_effective_date between effective_start_date and effective_end_date
1340: AND ppm_information_category = 'AE_AE DIRECT DEPOSIT AED'
1341: AND ppm_information1 = 'Y';