[Home] [Help]
4439: --
4440: CURSOR csr_get_pactid IS
4441: SELECT DISTINCT paa1.payroll_action_id
4442: FROM pay_assignment_actions paa
4443: ,pay_action_interlocks pal
4444: ,pay_assignment_actions paa1
4445: WHERE paa.payroll_action_id = p_actid
4446: AND paa.assignment_action_id = pal.locking_action_id
4447: AND pal.locked_action_id = paa1.assignment_action_id
4476: AND pai.action_context_id = ppa.payroll_action_id
4477: AND pai.action_information_category = 'NL_WR_SWMF_SECTOR_RISK_GROUP'
4478: AND EXISTS ( SELECT 1
4479: FROM pay_assignment_actions paa1
4480: ,pay_action_interlocks ai
4481: ,pay_assignment_actions paa2
4482: WHERE paa1.payroll_action_id = p_actid
4483: AND paa1.assignment_action_id = ai.locking_action_id
4484: AND ai.locked_action_id = paa2.assignment_action_id
4488: CURSOR csr_payroll_get_action_id(c_payroll_action_id NUMBER) IS
4489: SELECT max(locked_action_id)
4490: FROM pay_assignment_actions paa
4491: ,pay_payroll_actions ppa
4492: ,pay_action_interlocks pai
4493: WHERE ppa.payroll_action_id = c_payroll_action_id
4494: AND paa.payroll_action_id = ppa.payroll_action_id
4495: AND pai.locking_action_id = paa.assignment_action_id;
4496: --
4499: ,c_end_date DATE) IS
4500: SELECT max(paa2.assignment_action_id)
4501: FROM pay_assignment_actions paa
4502: ,pay_payroll_actions ppa
4503: ,pay_action_interlocks pai
4504: ,pay_assignment_actions paa1
4505: ,pay_assignment_actions paa2
4506: ,pay_payroll_actions ppa2
4507: WHERE ppa.payroll_action_id = c_payroll_action_id
9660: FROM DUAL
9661: WHERE EXISTS(SELECT /*+ ORDERED */ 1
9662: FROM pay_assignment_actions paa
9663: ,pay_payroll_actions ppa
9664: ,pay_action_interlocks pai
9665: ,pay_assignment_actions pal
9666: ,pay_payroll_actions ppl
9667: WHERE paa.assignment_id = c_assignment_id
9668: AND paa.payroll_action_id = ppa.payroll_action_id
13490: CURSOR csr_action_info(c_category VARCHAR2
13491: ,c_type VARCHAR2
13492: ,c_assignment_id NUMBER) IS
13493: SELECT pai.*
13494: FROM pay_action_interlocks pal
13495: ,pay_action_information pai
13496: WHERE pal.locking_action_id = p_assactid
13497: AND pal.locked_action_id = pai.action_context_id
13498: AND pai.action_context_type = 'AAP'
13503: --
13504: CURSOR csr_get_income_start_date(c_assactid NUMBER
13505: ,c_assignment_id NUMBER) IS
13506: SELECT MIN(fnd_date.canonical_to_date(action_information5))
13507: FROM pay_action_interlocks pal
13508: ,pay_action_information pai
13509: WHERE pal.locking_action_id = c_assactid
13510: AND pal.locked_action_id = pai.action_context_id
13511: AND pai.action_context_type = 'AAP'
13517: ,c_assignment_id NUMBER
13518: ,c_sector VARCHAR2
13519: ,c_risk_grp VARCHAR2) IS
13520: SELECT MIN(fnd_date.canonical_to_date(action_information5))
13521: FROM pay_action_interlocks pal
13522: ,pay_action_information pai
13523: WHERE pal.locking_action_id = c_assactid
13524: AND pal.locked_action_id = pai.action_context_id
13525: AND pai.action_context_type = 'AAP'
13587: ,sum(fnd_number.canonical_to_number(pai.action_information27)) sum27
13588: ,sum(fnd_number.canonical_to_number(pai.action_information28)) sum28
13589: ,sum(fnd_number.canonical_to_number(pai.action_information29)) sum29
13590: ,sum(fnd_number.canonical_to_number(pai.action_information30)) sum30
13591: from pay_action_interlocks pal
13592: ,pay_action_information pai
13593: where pal.locking_action_id = c_assactid
13594: AND pal.locked_action_id = pai.action_context_id
13595: AND pai.action_context_type = 'AAP'