APPS.PAY_US_NACHA_TAPE dependencies on PAY_PAYROLL_ACTIONS

Line 266: pay_payroll_actions ppa,

262: from pay_element_entry_values_f peev,
263: pay_input_values_f piv_att,
264: pay_element_entries_f peef,
265: pay_run_results prr,
266: pay_payroll_actions ppa,
267: pay_assignment_actions paa,
268: pay_action_interlocks pai,
269: pay_pre_payments ppp
270: WHERE ppp.value = p_amount

Line 334: pay_payroll_actions ppa,

330: pay_input_values_f piv_att,
331: pay_element_entries_f peef,
332: pay_run_results prr_att,
333: pay_run_results prr_pay,
334: pay_payroll_actions ppa,
335: pay_assignment_actions paa,
336: pay_action_interlocks pai,
337: pay_pre_payments ppp,
338: pay_input_values_f piv_pay,

Line 394: pay_payroll_actions ppa,

390: pay_input_values_f piv_att,
391: pay_element_entries_f peef,
392: pay_run_results prr_att,
393: pay_run_results prr_pay,
394: pay_payroll_actions ppa,
395: pay_assignment_actions paa,
396: pay_action_interlocks pai,
397: pay_pre_payments ppp,
398: pay_input_values_f piv_pay,

Line 1244: from pay_payroll_actions ppa,

1240: g_org_payment_method_id,
1241: g_legislative_parameters,
1242: g_csr_org_pay_third_party,
1243: g_payroll_id
1244: from pay_payroll_actions ppa,
1245: pay_org_payment_methods_f opm
1246: where ppa.payroll_action_id = g_payroll_action_id
1247: and opm.ORG_PAYMENT_METHOD_ID = ppa.org_payment_method_id
1248: and ppa.effective_date between opm.EFFECTIVE_START_DATE

Line 1501: pay_payroll_actions ppa

1497:
1498: CURSOR csr_get_payee_bank_details IS
1499: SELECT pea.segment1,pea.segment3,pea.segment5,pea.segment6
1500: FROM pay_external_accounts pea, pay_personal_payment_methods_f ppm,
1501: pay_payroll_actions ppa
1502: WHERE ppa.payroll_action_id = p_payroll_action_id
1503: AND ppm.personal_payment_method_id = p_personal_payment_method_id
1504: AND ppa.effective_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date
1505: AND pea.external_account_id (+) = ppm.external_account_id;

Line 1512: FROM pay_payroll_actions ppa, pay_org_payment_methods_f opm, pay_assignment_actions paa

1508:
1509: CURSOR csr_get_transact_date IS
1510: SELECT to_char(ppa.effective_date,'YYYY/MM/DD') effective_date,
1511: to_char(ppa.overriding_dd_date,'YYYY/MM/DD') overriding_dd_date
1512: FROM pay_payroll_actions ppa, pay_org_payment_methods_f opm, pay_assignment_actions paa
1513: WHERE ppa.payroll_action_id = p_payroll_action_id
1514: AND opm.org_payment_method_id = ppa.org_payment_method_id
1515: AND opm.org_payment_method_id = p_org_payment_method_id
1516: AND ppa.effective_date BETWEEN opm.effective_start_date AND opm.effective_end_date

Line 1526: pay_payroll_actions ppa, pay_assignment_actions paa

1522: CURSOR csr_get_batch_no IS
1523: SELECT ppp.org_payment_method_id, hou.organization_id, paa.assignment_action_id
1524: FROM pay_pre_payments ppp, pay_org_payment_methods_f opm,
1525: hr_organization_units hou, hr_organization_information hoi,
1526: pay_payroll_actions ppa, pay_assignment_actions paa
1527: WHERE opm.org_payment_method_id = ppp.org_payment_method_id
1528: AND opm.org_payment_method_id = ppa.org_payment_method_id
1529: AND opm.org_payment_method_id = p_org_payment_method_id
1530: AND ppa.payroll_action_id = p_payroll_action_id

Line 1583: FROM pay_org_payment_methods_f opm, pay_payroll_actions ppa,

1579: -- added opm.pmeth_information17 for 12848280
1580: CURSOR csr_get_conc_ident_values IS
1581: SELECT opm.pmeth_information3, nvl(opm.pmeth_information17,
1582: hoi.org_information4) org_information4
1583: FROM pay_org_payment_methods_f opm, pay_payroll_actions ppa,
1584: pay_assignment_actions paa, hr_organization_information hoi
1585: WHERE ppa.payroll_action_id = p_payroll_action_id
1586: AND ppa.effective_date BETWEEN opm.effective_start_date AND opm.effective_end_date
1587: AND ppa.org_payment_method_id = opm.org_payment_method_id