eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_NACHA_TAPE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 267: pay_assignment_actions paa,

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
271: and ppp.pre_payment_id = p_ppm_id

Line 335: pay_assignment_actions paa,

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,
339: pay_run_result_values prrv_att,

Line 395: pay_assignment_actions paa,

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,
399: pay_run_result_values prrv_att,

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 1584: pay_assignment_actions paa, hr_organization_information hoi

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
1588: AND ppa.payment_type_id = opm.payment_type_id