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_EMPLOYEE_PAYSLIP_WEB dependencies on PAY_PAYROLL_ACTIONS

Line 288: from pay_payroll_actions ppa,

284: from pay_action_interlocks pai_pre
285: where pai_pre.locking_action_id = cp_assignment_action_id
286: and exists (
287: select 1
288: from pay_payroll_actions ppa,
289: pay_assignment_actions paa,
290: pay_action_interlocks pai_run
291: /* Get the run assignment action id locked by pre-payment */
292: where pai_run.locked_action_id = pai_pre.locked_action_id

Line 308: pay_payroll_actions ppa

304: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
305: select paa.assignment_action_id
306: from pay_action_interlocks paci,
307: pay_assignment_actions paa,
308: pay_payroll_actions ppa
309: where paci.locking_action_id = cp_assignment_action_id
310: and paa.assignment_action_id = paci.locked_action_id
311: and ppa.payroll_action_id = paa.payroll_action_id
312: and ppa.action_type in ('P', 'U');

Line 326: pay_payroll_actions ppa_pre

322: select paa_pre.assignment_action_id
323: from pay_action_interlocks pai_run,
324: pay_action_interlocks pai_pre,
325: pay_assignment_actions paa_pre,
326: pay_payroll_actions ppa_pre
327: where pai_run.locking_action_id = cp_assignment_action_id
328: and pai_pre.locked_action_id = pai_run.locked_action_id
329: and paa_pre.assignment_Action_id = pai_pre.locking_action_id
330: and ppa_pre.payroll_action_id = paa_pre.payroll_action_id

Line 335: from pay_payroll_actions ppa

331: and ppa_pre.action_type in ('P', 'U');
332:
333: cursor c_get_date_earned(cp_assignment_action_id in number) is
334: select nvl(max(ppa.date_earned), max(ppa.effective_date))
335: from pay_payroll_actions ppa
336: ,pay_assignment_actions paa
337: ,pay_action_interlocks pai
338: where ppa.payroll_action_id = paa.payroll_action_id
339: and pai.locked_action_id = paa.assignment_action_id

Line 859: from pay_payroll_actions ppa,

855: from pay_action_interlocks pai_pre
856: where pai_pre.locking_action_id = cp_assignment_action_id
857: and exists (
858: select 1
859: from pay_payroll_actions ppa,
860: pay_assignment_actions paa,
861: pay_action_interlocks pai_run
862: /* Get the run assignment action id locked by pre-payment */
863: where pai_run.locked_action_id = pai_pre.locked_action_id

Line 879: pay_payroll_actions ppa

875: cursor c_prepay_arch_action(cp_assignment_action_id in number) is
876: select paa.assignment_action_id
877: from pay_action_interlocks paci,
878: pay_assignment_actions paa,
879: pay_payroll_actions ppa
880: where paci.locking_action_id = cp_assignment_action_id
881: and paa.assignment_action_id = paci.locked_action_id
882: and ppa.payroll_action_id = paa.payroll_action_id
883: and ppa.action_type in ('P', 'U');

Line 897: pay_payroll_actions ppa_pre

893: select paa_pre.assignment_action_id
894: from pay_action_interlocks pai_run,
895: pay_action_interlocks pai_pre,
896: pay_assignment_actions paa_pre,
897: pay_payroll_actions ppa_pre
898: where pai_run.locking_action_id = cp_assignment_action_id
899: and pai_pre.locked_action_id = pai_run.locked_action_id
900: and paa_pre.assignment_Action_id = pai_pre.locking_action_id
901: and ppa_pre.payroll_action_id = paa_pre.payroll_action_id

Line 907: FROM pay_payroll_actions ppa

903:
904: --Modified Cursor for bug 8550075
905: CURSOR c_get_date_earned(cp_assignment_action_id IN NUMBER) IS
906: SELECT nvl(MAX(ppa.date_earned), MAX(ppa.effective_date)), MAX(ppa.effective_date), BUSINESS_GROUP_ID
907: FROM pay_payroll_actions ppa
908: , pay_assignment_actions paa
909: , pay_action_interlocks pai
910: WHERE ppa.payroll_action_id = paa.payroll_action_id
911: AND pai.locked_action_id = paa.assignment_action_id

Line 939: pay_payroll_actions ppa2

935: from pay_action_interlocks ai
936: where ai.locking_action_id = paa.assignment_action_id )
937: and exists
938: (select 1 from pay_assignment_actions paa2,
939: pay_payroll_actions ppa2
940: where paa2.assignment_id = paa.assignment_id
941: and paa2.payroll_action_id = ppa2.payroll_action_id
942: and ppa2.action_type = 'Z');
943:

Line 978: pay_payroll_actions ppa

974:
975: cursor c_get_completion_status(cp_assignment_action_id in number) is
976: select 1
977: from pay_assignment_actions paa,
978: pay_payroll_actions ppa
979: where paa.assignment_action_id = cp_assignment_action_id
980: and paa.payroll_action_id = ppa.payroll_action_id
981: and paa.assignment_id = p_assignment_id
982: and paa.action_status = 'C'

Line 1299: from pay_payroll_actions ppa

1295: RETURN VARCHAR2 IS
1296:
1297: cursor c_get_date_earned(cp_assignment_action_id in number) is
1298: select nvl(max(ppa.date_earned), max(ppa.effective_date))
1299: from pay_payroll_actions ppa
1300: ,pay_assignment_actions paa
1301: ,pay_action_interlocks pai
1302: where ppa.payroll_action_id = paa.payroll_action_id
1303: and pai.locked_action_id = paa.assignment_action_id

Line 1391: pay_payroll_actions ppa

1387: from pay_run_results prr,
1388: pay_run_result_values prrv,
1389: pay_input_values_f piv,
1390: pay_assignment_actions paa,
1391: pay_payroll_actions ppa
1392: where prr.element_type_id = piv.element_type_id
1393: and prr.run_result_id = prrv.run_result_id
1394: and prr.source_type = 'E'
1395: and piv.input_value_id = prrv.input_value_id

Line 1413: pay_payroll_actions ppa

1409: from pay_run_results prr,
1410: pay_run_result_values prrv,
1411: pay_input_values_f piv,
1412: pay_assignment_actions paa,
1413: pay_payroll_actions ppa
1414: where prr.element_type_id = piv.element_type_id
1415: and prr.run_result_id = prrv.run_result_id
1416: and prr.source_type = 'E'
1417: and piv.input_value_id = prrv.input_value_id

Line 1713: pay_payroll_actions ppa_pymt,

1709: 'M', to_char(NVL(ppp.source_action_id,cp_pre_payment_action)),
1710: paa_pymt.serial_number)
1711: from pay_pre_payments ppp,
1712: pay_assignment_actions paa_pymt,
1713: pay_payroll_actions ppa_pymt,
1714: pay_action_interlocks pai
1715: where pai.locked_action_id = cp_pre_payment_action
1716: and paa_pymt.assignment_action_id = pai.locking_action_id
1717: and ppa_pymt.payroll_action_id = paa_pymt.payroll_action_id

Line 1723: from pay_payroll_actions ppa,

1719: and paa_pymt.pre_payment_id = cp_pre_payment_id
1720: and ppp.pre_payment_id = paa_pymt.pre_payment_id
1721: and not exists (
1722: select 1
1723: from pay_payroll_actions ppa,
1724: pay_assignment_actions paa,
1725: pay_action_interlocks pai_void
1726: /* Assignment Action of Payment Type - NACHA/Check */
1727: where pai_void.locked_action_id = paa_pymt.assignment_action_id --Void

Line 2614: pay_payroll_actions ppa

2610: SELECT
2611: paci.locked_action_id
2612: FROM pay_action_interlocks paci,
2613: pay_assignment_actions paa,
2614: pay_payroll_actions ppa
2615: WHERE paci.locking_action_id = v_action_context_id
2616: AND paa.assignment_action_id = paci.locked_action_id
2617: AND ppa.payroll_action_id = paa.payroll_action_id
2618: AND ppa.action_type IN ( 'P' , 'U' );

Line 2918: FROM pay_payroll_actions ppa,

2914: FROM pay_action_interlocks pai_pre
2915: WHERE pai_pre.locking_action_id = cp_assignment_action_id
2916: AND EXISTS (
2917: SELECT 1
2918: FROM pay_payroll_actions ppa,
2919: pay_assignment_actions paa,
2920: pay_action_interlocks pai_run
2921: /* Get the run assignment action id locked by pre-payment */
2922: WHERE pai_run.locked_action_id = pai_pre.locked_action_id

Line 2938: pay_payroll_actions ppa

2934: CURSOR c_prepay_arch_action(cp_assignment_action_id IN NUMBER) IS
2935: SELECT paa.assignment_action_id
2936: FROM pay_action_interlocks paci,
2937: pay_assignment_actions paa,
2938: pay_payroll_actions ppa
2939: WHERE paci.locking_action_id = cp_assignment_action_id
2940: AND paa.assignment_action_id = paci.locked_action_id
2941: AND ppa.payroll_action_id = paa.payroll_action_id
2942: AND ppa.action_type IN ('P', 'U');

Line 2956: pay_payroll_actions ppa_pre

2952: SELECT paa_pre.assignment_action_id
2953: FROM pay_action_interlocks pai_run,
2954: pay_action_interlocks pai_pre,
2955: pay_assignment_actions paa_pre,
2956: pay_payroll_actions ppa_pre
2957: WHERE pai_run.locking_action_id = cp_assignment_action_id
2958: AND pai_pre.locked_action_id = pai_run.locked_action_id
2959: AND paa_pre.assignment_Action_id = pai_pre.locking_action_id
2960: AND ppa_pre.payroll_action_id = paa_pre.payroll_action_id

Line 2966: FROM pay_payroll_actions ppa

2962:
2963: --Modified Cursor for bug 8550075
2964: CURSOR c_get_date_earned(cp_assignment_action_id IN NUMBER) IS
2965: SELECT nvl(MAX(ppa.date_earned), MAX(ppa.effective_date)), MAX(ppa.effective_date), BUSINESS_GROUP_ID
2966: FROM pay_payroll_actions ppa
2967: , pay_assignment_actions paa
2968: , pay_action_interlocks pai
2969: WHERE ppa.payroll_action_id = paa.payroll_action_id
2970: AND pai.locked_action_id = paa.assignment_action_id