DBA Data[Home] [Help]

APPS.PER_NL_DSR_ARCHIVE dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 1505: FROM pay_personal_payment_methods_f pppm

1501: , p_start_date IN DATE) IS
1502: SELECT upper(pea.segment2) acc_no
1503: ,pea.segment9 bic
1504: ,pea.segment10 iban
1505: FROM pay_personal_payment_methods_f pppm
1506: ,pay_external_accounts pea
1507: WHERE pppm.assignment_id = p_assignment_id
1508: AND p_start_date BETWEEN pppm.effective_start_date
1509: AND pppm.effective_end_date