[Home] [Help]
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'
974: and pai_emp.action_context_id in( select paa.assignment_action_id
975: from pay_action_information pai_comp,
976: pay_action_information pai_person,
977: pay_assignment_actions paa,
978: pay_payroll_actions ppa
979: where ppa.payroll_action_id = p_pactid
980: and paa.payroll_action_id = ppa.payroll_action_id
981: and pai_comp.action_context_id = paa.assignment_action_id
982: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'
1129: and pai_emp.action_context_id in ( select paa.assignment_action_id
1130: from pay_action_information pai_comp,
1131: pay_action_information pai_person,
1132: pay_assignment_actions paa,
1133: pay_payroll_actions ppa
1134: where ppa.payroll_action_id = p_pactid
1135: and paa.payroll_action_id = ppa.payroll_action_id
1136: and pai_comp.action_context_id = paa.assignment_action_id
1137: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'
1773: begin
1774: retcode := 0;
1775: select legislative_parameters
1776: into l_param_string
1777: from pay_payroll_actions
1778: where payroll_action_id = p_payroll_action_id;
1779: -- check if the archiver has Status in it
1780: -- if not then it is old archiver 2002-2003 archiver.
1781: -- the one prior to self service being supplied.
1785: raise Old_Archive;
1786: end if;
1787: l_param_string_before_val := substr(l_param_string,1,instr(l_param_string, ' Status=')-2) ;
1788: l_param_string_after_val := substr(l_param_string,instr(l_param_string, 'Status=') + length('Status=')+1) ;
1789: update pay_payroll_actions
1790: set legislative_parameters =l_param_string_before_val || p_new_status ||
1791: ' Status=' || p_new_status || l_param_string_after_val
1792: where payroll_action_id = p_payroll_action_id; --8875;
1793: exception
2034: -- if we add further params then the below would not work!
2035: select substr(legislative_parameters,
2036: instr(legislative_parameters, 'NOTES=') + (length('NOTES=')))
2037: into l_notes
2038: from pay_payroll_actions
2039: where payroll_action_id = p_payroll_action_id;
2040: return l_notes;
2041: exception
2042: when others then
2140: use_index(pai_comp,pay_action_information_n2)
2141: use_index(pai_person,pay_action_information_n2)
2142: use_index(pai_car,pay_action_information_n2) */
2143: pai_car.action_context_id
2144: from pay_payroll_actions ppa,
2145: pay_assignment_actions paa,
2146: pay_action_information pai_comp,
2147: pay_action_information pai_person,
2148: pay_action_information pai_car
2325: --
2326: cursor pay_effective_date(c_payroll_action_id in number)
2327: is
2328: select pay.effective_date
2329: from pay_payroll_actions pay
2330: where pay.payroll_action_id = c_payroll_action_id;
2331: --
2332: begin
2333: if p_payroll_action_id = 0
2561: use_index(pai_comp,pay_action_information_n2)
2562: use_index(pai_person,pay_action_information_n2)
2563: use_index(pai_car,pay_action_information_n2) */
2564: pai_car.action_context_id
2565: from pay_payroll_actions ppa,
2566: pay_assignment_actions paa,
2567: pay_action_information pai_comp,
2568: pay_action_information pai_person,
2569: pay_action_information pai_car
3459: and action_context_id in (select paa.assignment_action_id
3460: from pay_action_information pai_comp,
3461: pay_action_information pai_person,
3462: pay_assignment_actions paa,
3463: pay_payroll_actions ppa
3464: where ppa.payroll_action_id = p_pactid
3465: and paa.payroll_action_id = ppa.payroll_action_id
3466: and pai_comp.action_context_id = paa.assignment_action_id
3467: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'
3508: and action_context_id in (select paa.assignment_action_id
3509: from pay_action_information pai_comp,
3510: pay_action_information pai_person,
3511: pay_assignment_actions paa,
3512: pay_payroll_actions ppa
3513: where ppa.payroll_action_id = p_pactid
3514: and paa.payroll_action_id = ppa.payroll_action_id
3515: and pai_comp.action_context_id = paa.assignment_action_id
3516: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'
3535: and action_context_id in (select paa.assignment_action_id
3536: from pay_action_information pai_comp,
3537: pay_action_information pai_person,
3538: pay_assignment_actions paa,
3539: pay_payroll_actions ppa
3540: where ppa.payroll_action_id = p_pactid
3541: and paa.payroll_action_id = ppa.payroll_action_id
3542: and pai_comp.action_context_id = paa.assignment_action_id
3543: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'
3596: and action_context_id in (select paa.assignment_action_id
3597: from pay_action_information pai_comp,
3598: pay_action_information pai_person,
3599: pay_assignment_actions paa,
3600: pay_payroll_actions ppa
3601: where ppa.payroll_action_id = p_pactid
3602: and paa.payroll_action_id = ppa.payroll_action_id
3603: and pai_comp.action_context_id = paa.assignment_action_id
3604: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'
3624: and action_context_id in (select paa.assignment_action_id
3625: from pay_action_information pai_comp,
3626: pay_action_information pai_person,
3627: pay_assignment_actions paa,
3628: pay_payroll_actions ppa
3629: where ppa.payroll_action_id = p_pactid
3630: and paa.payroll_action_id = ppa.payroll_action_id
3631: and pai_comp.action_context_id = paa.assignment_action_id
3632: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'
4055: and action_context_id in(select paa.assignment_action_id
4056: from pay_action_information pai_comp,
4057: pay_action_information pai_person,
4058: pay_assignment_actions paa,
4059: pay_payroll_actions ppa
4060: where ppa.payroll_action_id = p_pactid
4061: and paa.payroll_action_id = ppa.payroll_action_id
4062: and pai_comp.action_context_id = paa.assignment_action_id
4063: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'
4241: and pai_ben.action_context_id in ( select paa.assignment_action_id
4242: from pay_action_information pai_comp,
4243: pay_action_information pai_person,
4244: pay_assignment_actions paa,
4245: pay_payroll_actions ppa
4246: where ppa.payroll_action_id = p_pactid
4247: and paa.payroll_action_id = ppa.payroll_action_id
4248: and pai_comp.action_context_id = paa.assignment_action_id
4249: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'
4757: and action_context_id in ( select paa.assignment_action_id
4758: from pay_action_information pai_comp,
4759: pay_action_information pai_person,
4760: pay_assignment_actions paa,
4761: pay_payroll_actions ppa
4762: where ppa.payroll_action_id = p_pactid
4763: and paa.payroll_action_id = ppa.payroll_action_id
4764: and pai_comp.action_context_id = paa.assignment_action_id
4765: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'
4892: and action_context_id in ( select paa.assignment_action_id
4893: from pay_action_information pai_comp,
4894: pay_action_information pai_person,
4895: pay_assignment_actions paa,
4896: pay_payroll_actions ppa
4897: where ppa.payroll_action_id = p_pactid
4898: and paa.payroll_action_id = ppa.payroll_action_id
4899: and pai_comp.action_context_id = paa.assignment_action_id
4900: and pai_comp.action_information_category = 'EMEA PAYROLL INFO'