DBA Data[Home] [Help]

APPS.PER_NL_DSR_ARCHIVE dependencies on PAY_EXTERNAL_ACCOUNTS

Line 1453: ,pay_external_accounts pea

1449: ,pea.segment10 iban
1450: FROM per_all_assignments_f pas
1451: ,pay_payrolls_f pp
1452: ,pay_org_payment_methods_f popm
1453: ,pay_external_accounts pea
1454: WHERE pas.assignment_id = p_assignment_id
1455: AND pas.payroll_id = pp.payroll_id
1456: AND p_start_date BETWEEN pp.effective_start_date
1457: AND pp.effective_end_date

Line 1506: ,pay_external_accounts pea

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
1510: AND pppm.external_account_id = pea.external_account_id