DBA Data[Home] [Help]

APPS.PER_NL_WAZO_ARCHIVE dependencies on PAY_EXTERNAL_ACCOUNTS

Line 1298: ,pay_external_accounts pea

1294: ,pea.segment10 iban
1295: FROM per_all_assignments_f pas
1296: ,pay_payrolls_f pp
1297: ,pay_org_payment_methods_f popm
1298: ,pay_external_accounts pea
1299: WHERE pas.assignment_id = p_assignment_id
1300: AND pas.payroll_id = pp.payroll_id
1301: AND p_start_date BETWEEN pp.effective_start_date
1302: AND pp.effective_end_date

Line 1339: ,pay_external_accounts pea

1335: SELECT upper(pea.segment2) acc_no
1336: ,pea.segment9 bic
1337: ,pea.segment10 iban
1338: FROM pay_personal_payment_methods_f pppm
1339: ,pay_external_accounts pea
1340: WHERE pppm.assignment_id = p_assignment_id
1341: AND p_start_date BETWEEN pppm.effective_start_date
1342: AND pppm.effective_end_date
1343: AND pppm.external_account_id = pea.external_account_id