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_IP_PAYROLL_ARCH dependencies on PAY_ACTION_INTERLOCKS

Line 741: pay_action_interlocks pai,

737: FROM pay_element_types_f petf,
738: pay_element_types_f_tl petfl,
739: pay_element_classifications pec,
740: pay_run_results prr,
741: pay_action_interlocks pai,
742: pay_assignment_actions paa_pre,
743: pay_payroll_actions ppa_pre
744: WHERE ppa_pre.action_type IN ('U', 'P')
745: AND ppa_pre.effective_date > cp_last_xfr_eff_date

Line 1470: pay_action_interlocks pai,

1466: pay_element_types_f_tl petl,
1467: pay_element_classifications pec,
1468: pay_run_results prr,
1469: pay_assignment_actions paa,
1470: pay_action_interlocks pai,
1471: pay_payroll_actions ppa
1472: WHERE
1473: petf.element_type_id = prr.element_type_id
1474: AND pec.classification_id = petf.classification_id

Line 1851: ,pay_action_interlocks pai

1847: ,pay_input_values_f piv
1848: ,pay_element_types_f pet
1849: ,pay_element_types_f_tl petl
1850: ,pay_element_classifications pec
1851: ,pay_action_interlocks pai
1852: ,per_assignments_f paf
1853: WHERE ppa.action_type IN ('R','Q','B','V')
1854: AND ppa.action_status = 'C'
1855: AND ppa.payroll_action_id = paa.payroll_action_id

Line 2324: FROM pay_action_interlocks pai,

2320: AND ppa.effective_date BETWEEN paf.effective_start_date
2321: AND paf.effective_end_date
2322: AND NOT EXISTS
2323: (SELECT ''x''
2324: FROM pay_action_interlocks pai,
2325: pay_assignment_actions paa1,
2326: pay_payroll_actions ppa1
2327: WHERE pai.locked_action_id = paa.assignment_action_id
2328: AND paa1.assignment_action_id = pai.locking_action_id

Line 2395: FROM pay_action_interlocks pai1,

2391: 'N') = 'N'
2392: AND paa.source_action_id IS NULL
2393: AND NOT EXISTS
2394: (SELECT 'x'
2395: FROM pay_action_interlocks pai1,
2396: pay_assignment_actions paa1,
2397: pay_payroll_actions ppa1
2398: WHERE pai1.locked_action_id = paa.assignment_action_id
2399: AND paa1.assignment_action_id = pai1.locking_action_id

Line 2446: FROM pay_action_interlocks pai1,

2442: 'N') = 'N'
2443: AND paa.source_action_id IS NULL
2444: AND NOT EXISTS
2445: (SELECT 'x'
2446: FROM pay_action_interlocks pai1,
2447: pay_assignment_actions paa1,
2448: pay_payroll_actions ppa1
2449: WHERE pai1.locked_action_id = paa.assignment_action_id
2450: AND paa1.assignment_action_id = pai1.locking_action_id

Line 2460: pay_action_interlocks pai

2456: CURSOR c_master_action(cp_prepayment_action_id NUMBER) IS
2457: SELECT MAX(paa.assignment_action_id)
2458: FROM pay_payroll_actions ppa,
2459: pay_assignment_actions paa,
2460: pay_action_interlocks pai
2461: WHERE pai.locking_action_Id = cp_prepayment_action_id
2462: AND paa.assignment_action_id = pai.locked_action_id
2463: AND paa.source_action_id IS NULL
2464: AND ppa.payroll_action_id = paa.payroll_action_id

Line 3707: pay_action_interlocks pai,

3703: CURSOR c_ytd_aaid(cp_prepayment_action_id IN NUMBER
3704: ,cp_assignment_id IN NUMBER) IS
3705: SELECT paa.assignment_action_id
3706: FROM pay_assignment_actions paa,
3707: pay_action_interlocks pai,
3708: pay_payroll_actions ppa
3709: WHERE pai.locking_action_id = cp_prepayment_action_id
3710: AND paa.assignment_action_id = pai.locked_action_id
3711: AND paa.assignment_id = cp_assignment_id

Line 4139: FROM pay_action_interlocks pai,

4135: WHERE paa.assignment_action_id = cp_assignment_action;
4136:
4137: CURSOR c_assignment_run (cp_prepayment_action_id IN NUMBER) IS
4138: SELECT DISTINCT paa.assignment_id
4139: FROM pay_action_interlocks pai,
4140: pay_assignment_actions paa,
4141: pay_payroll_actions ppa
4142: WHERE pai.locking_action_id = cp_prepayment_action_id
4143: AND paa.assignment_action_id = pai.locked_action_id

Line 4159: pay_action_interlocks pai

4155: SELECT paa.assignment_action_id, paa.payroll_action_id,
4156: ppa.action_type
4157: FROM pay_payroll_actions ppa,
4158: pay_assignment_actions paa,
4159: pay_action_interlocks pai
4160: WHERE pai.locking_action_id = cp_prepayment_action_id
4161: AND pai.locked_action_id = paa.assignment_action_id
4162: AND paa.assignment_id = cp_assignment_id
4163: AND paa.source_action_id IS NULL

Line 4195: ,pay_action_interlocks pai

4191: ,cp_tax_unit_id NUMBER) IS
4192: SELECT paa.assignment_action_id
4193: ,paa.source_action_id
4194: FROM pay_assignment_actions paa
4195: ,pay_action_interlocks pai
4196: where pai.locking_action_id = cp_pp_asg_act_id
4197: AND paa.assignment_action_id = pai.locked_action_id
4198: AND paa.assignment_id = cp_assignment_id
4199: AND ((paa.tax_unit_id = cp_tax_unit_id)

Line 4227: ,pay_action_interlocks pai

4223: ,cp_tax_unit_id NUMBER) IS
4224: SELECT paa.assignment_action_id
4225: ,paa.source_action_id
4226: FROM pay_assignment_actions paa
4227: ,pay_action_interlocks pai
4228: WHERE pai.locking_action_id = cp_pp_asg_act_id
4229: AND paa.assignment_action_id = pai.locked_action_id
4230: AND paa.assignment_id = cp_assignment_id
4231: AND ((paa.tax_unit_id = cp_tax_unit_id)

Line 4241: pay_action_interlocks pai

4237: ,cp_tax_unit_id IN NUMBER
4238: ,cp_legislation_code IN VARCHAR2) IS
4239: SELECT paa.assignment_action_id
4240: FROM pay_assignment_actions paa,
4241: pay_action_interlocks pai
4242: WHERE pai.locking_action_id = cp_pp_asg_act_id
4243: AND paa.assignment_action_id = pai.locked_action_id
4244: AND paa.assignment_id = cp_assignment_id
4245: AND ((paa.tax_unit_id = cp_tax_unit_id)

Line 4257: FROM pay_action_interlocks

4253: AND prt.run_method = 'C' );
4254:
4255: CURSOR c_get_emp_adjbal(cp_xfr_action_id NUMBER) IS
4256: SELECT locked_action_id
4257: FROM pay_action_interlocks
4258: WHERE locking_action_id = cp_xfr_action_id;
4259:
4260: ld_curr_pymt_eff_date DATE;
4261: ln_sepchk_run_type_id NUMBER;