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.HR_GB_PROCESS_P11D_ENTRIES_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 326: pay_payroll_actions ppa

322: from pay_action_information pai_comp,
323: pay_action_information pai_person,
324: pay_action_information pai,
325: pay_assignment_actions paa,
326: pay_payroll_actions ppa
327: where ppa.payroll_action_id = p_archive_payroll_action_id
328: and ppa.payroll_action_id = paa.payroll_action_id
329: and pai_comp.action_context_id = paa.assignment_action_id
330: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 987: pay_payroll_actions ppa

983: and pai_emp.action_context_id in( select paa.assignment_action_id
984: from pay_action_information pai_comp,
985: pay_action_information pai_person,
986: pay_assignment_actions paa,
987: pay_payroll_actions ppa
988: where ppa.payroll_action_id = p_pactid
989: and paa.payroll_action_id = ppa.payroll_action_id
990: and pai_comp.action_context_id = paa.assignment_action_id
991: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 1154: pay_payroll_actions ppa

1150: and pai_emp.action_context_id in ( select paa.assignment_action_id
1151: from pay_action_information pai_comp,
1152: pay_action_information pai_person,
1153: pay_assignment_actions paa,
1154: pay_payroll_actions ppa
1155: where ppa.payroll_action_id = p_pactid
1156: and paa.payroll_action_id = ppa.payroll_action_id
1157: and pai_comp.action_context_id = paa.assignment_action_id
1158: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 2229: from pay_payroll_actions

2225: begin
2226: retcode := 0;
2227: select legislative_parameters
2228: into l_param_string
2229: from pay_payroll_actions
2230: where payroll_action_id = p_payroll_action_id;
2231: -- check if the archiver has Status in it
2232: -- if not then it is old archiver 2002-2003 archiver.
2233: -- the one prior to self service being supplied.

Line 2241: update pay_payroll_actions

2237: raise Old_Archive;
2238: end if;
2239: l_param_string_before_val := substr(l_param_string,1,instr(l_param_string, ' Status=')-2) ;
2240: l_param_string_after_val := substr(l_param_string,instr(l_param_string, 'Status=') + length('Status=')+1) ;
2241: update pay_payroll_actions
2242: set legislative_parameters =l_param_string_before_val || p_new_status ||
2243: ' Status=' || p_new_status || l_param_string_after_val
2244: where payroll_action_id = p_payroll_action_id; --8875;
2245: exception

Line 2490: from pay_payroll_actions

2486: -- if we add further params then the below would not work!
2487: select substr(legislative_parameters,
2488: instr(legislative_parameters, 'NOTES=') + (length('NOTES=')))
2489: into l_notes
2490: from pay_payroll_actions
2491: where payroll_action_id = p_payroll_action_id;
2492: return l_notes;
2493: exception
2494: when others then

Line 2618: from pay_payroll_actions ppa,

2614: use_index(pai_comp,pay_action_information_n2)
2615: use_index(pai_person,pay_action_information_n2)
2616: use_index(pai_car,pay_action_information_n2) */
2617: pai_car.action_context_id
2618: from pay_payroll_actions ppa,
2619: pay_assignment_actions paa,
2620: pay_action_information pai_comp,
2621: pay_action_information pai_person,
2622: pay_action_information pai_car

Line 2815: from pay_payroll_actions pay

2811: --
2812: cursor pay_effective_date(c_payroll_action_id in number)
2813: is
2814: select pay.effective_date
2815: from pay_payroll_actions pay
2816: where pay.payroll_action_id = c_payroll_action_id;
2817: --
2818: begin
2819: if p_payroll_action_id = 0

Line 3051: from pay_payroll_actions ppa,

3047: use_index(pai_comp,pay_action_information_n2)
3048: use_index(pai_person,pay_action_information_n2)
3049: use_index(pai_car,pay_action_information_n2) */
3050: pai_car.action_context_id
3051: from pay_payroll_actions ppa,
3052: pay_assignment_actions paa,
3053: pay_action_information pai_comp,
3054: pay_action_information pai_person,
3055: pay_action_information pai_car

Line 4120: pay_payroll_actions ppa

4116: and action_context_id in (select paa.assignment_action_id
4117: from pay_action_information pai_comp,
4118: pay_action_information pai_person,
4119: pay_assignment_actions paa,
4120: pay_payroll_actions ppa
4121: where ppa.payroll_action_id = p_pactid
4122: and paa.payroll_action_id = ppa.payroll_action_id
4123: and pai_comp.action_context_id = paa.assignment_action_id
4124: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 4169: pay_payroll_actions ppa

4165: and action_context_id in (select paa.assignment_action_id
4166: from pay_action_information pai_comp,
4167: pay_action_information pai_person,
4168: pay_assignment_actions paa,
4169: pay_payroll_actions ppa
4170: where ppa.payroll_action_id = p_pactid
4171: and paa.payroll_action_id = ppa.payroll_action_id
4172: and pai_comp.action_context_id = paa.assignment_action_id
4173: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 4196: pay_payroll_actions ppa

4192: and action_context_id in (select paa.assignment_action_id
4193: from pay_action_information pai_comp,
4194: pay_action_information pai_person,
4195: pay_assignment_actions paa,
4196: pay_payroll_actions ppa
4197: where ppa.payroll_action_id = p_pactid
4198: and paa.payroll_action_id = ppa.payroll_action_id
4199: and pai_comp.action_context_id = paa.assignment_action_id
4200: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 4257: pay_payroll_actions ppa

4253: and action_context_id in (select paa.assignment_action_id
4254: from pay_action_information pai_comp,
4255: pay_action_information pai_person,
4256: pay_assignment_actions paa,
4257: pay_payroll_actions ppa
4258: where ppa.payroll_action_id = p_pactid
4259: and paa.payroll_action_id = ppa.payroll_action_id
4260: and pai_comp.action_context_id = paa.assignment_action_id
4261: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 4285: pay_payroll_actions ppa

4281: and action_context_id in (select paa.assignment_action_id
4282: from pay_action_information pai_comp,
4283: pay_action_information pai_person,
4284: pay_assignment_actions paa,
4285: pay_payroll_actions ppa
4286: where ppa.payroll_action_id = p_pactid
4287: and paa.payroll_action_id = ppa.payroll_action_id
4288: and pai_comp.action_context_id = paa.assignment_action_id
4289: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 4728: pay_payroll_actions ppa

4724: and action_context_id in(select paa.assignment_action_id
4725: from pay_action_information pai_comp,
4726: pay_action_information pai_person,
4727: pay_assignment_actions paa,
4728: pay_payroll_actions ppa
4729: where ppa.payroll_action_id = p_pactid
4730: and paa.payroll_action_id = ppa.payroll_action_id
4731: and pai_comp.action_context_id = paa.assignment_action_id
4732: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 4926: pay_payroll_actions ppa

4922: and pai_ben.action_context_id in ( select paa.assignment_action_id
4923: from pay_action_information pai_comp,
4924: pay_action_information pai_person,
4925: pay_assignment_actions paa,
4926: pay_payroll_actions ppa
4927: where ppa.payroll_action_id = p_pactid
4928: and paa.payroll_action_id = ppa.payroll_action_id
4929: and pai_comp.action_context_id = paa.assignment_action_id
4930: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 5542: pay_payroll_actions ppa

5538: and action_context_id in ( select paa.assignment_action_id
5539: from pay_action_information pai_comp,
5540: pay_action_information pai_person,
5541: pay_assignment_actions paa,
5542: pay_payroll_actions ppa
5543: where ppa.payroll_action_id = p_pactid
5544: and paa.payroll_action_id = ppa.payroll_action_id
5545: and pai_comp.action_context_id = paa.assignment_action_id
5546: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'

Line 5677: pay_payroll_actions ppa

5673: and action_context_id in ( select paa.assignment_action_id
5674: from pay_action_information pai_comp,
5675: pay_action_information pai_person,
5676: pay_assignment_actions paa,
5677: pay_payroll_actions ppa
5678: where ppa.payroll_action_id = p_pactid
5679: and paa.payroll_action_id = ppa.payroll_action_id
5680: and pai_comp.action_context_id = paa.assignment_action_id
5681: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'