[Home] [Help]
180:
181: CURSOR csr_locked_asgs
182: IS
183: SELECT DISTINCT paa.assignment_id,paa.assignment_action_id,paa.payroll_action_id
184: FROM pay_assignment_actions paa,
185: pay_payroll_actions ppa,
186: pay_action_information pai,
187: per_assignments_f paaf,
188: pay_all_payrolls_f ppf,
256: )))
257: OR l_assignment_set_id IS NULL)
258: AND NOT EXISTS (
259: SELECT 1
260: FROM pay_assignment_actions paa_p35,
261: pay_payroll_actions ppa_p35,
262: per_assignments_f paaf_p35,
263: pay_all_payrolls_f ppf_p35,
264: hr_soft_coding_keyflex flex_p35,
276: --AND paa_p35.assignment_id = asg.assignment_id
277: AND paa_p35.assignment_id = paaf_p35.assignment_id
278: AND paaf_p35.person_id = paaf.person_id
279: AND paa_p35.assignment_action_id = plock.locking_action_id
280: AND plock.locked_action_id IN (SELECT assignment_action_id FROM pay_assignment_actions
281: WHERE assignment_id=paaf.assignment_id)
282: AND paaf_p35.payroll_id = ppf_p35.payroll_id
283: AND ppf_p35.soft_coding_keyflex_id = flex_p35.soft_coding_keyflex_id
284: AND flex_p35.segment4 = l_segment4);
345: hr_utility.set_location ('Selected assignment ::'|| c_rec.assignment_id || ' ::and action ::passed to action creation::'||
346: c_rec.assignment_action_id||'::',960);
347: hr_utility.set_location ('Selected payroll_action::'||c_rec.payroll_action_id ,960);
348:
349: SELECT pay_assignment_actions_s.NEXTVAL
350: INTO l_actid
351: FROM DUAL;
352:
353: -- insert into pay_assignment_actions.
349: SELECT pay_assignment_actions_s.NEXTVAL
350: INTO l_actid
351: FROM DUAL;
352:
353: -- insert into pay_assignment_actions.
354: hr_nonrun_asact.insact (
355: l_actid,
356: c_rec.assignment_id,
357: pactid,
445: count(decode(pact.action_information6,0,null,null,null,1)) EMP_RAC,
446: sum(to_number(pact.action_information6))*100 EMP_RAC_BAL,
447: sum(to_number(pact.action_information1))*100 TAXABLEBENEFITS
448:
449: FROM pay_assignment_actions paa
450: ,pay_action_information pact
451: ,pay_action_interlocks pai
452: WHERE paa.payroll_action_id = p_payroll_action_id
453: AND paa.source_action_id IS NULL
472: count(decode(pact.action_information6,0,null,null,null,1)) EMP_RAC,
473: TRUNC(sum(to_number(pact.action_information6)))*100 EMP_RAC_BAL,
474: TRUNC(sum(to_number(pact.action_information1)))*100 TAXABLEBENEFITS
475:
476: FROM pay_assignment_actions paa
477: ,pay_action_information pact
478: ,pay_action_interlocks pai
479: WHERE paa.payroll_action_id = p_payroll_action_id
480: AND paa.source_action_id IS NULL
553: select count(decode(pact.action_information23,0,null,null,null,1)) EMP_PARKING, /* knadhan */
554: sum(to_number(pact.action_information23))*100 EMP_PARKING_BAL ,
555: nvl((sum(to_number(pact.action_information19))*100),0) empr_income_band /* sum of first band, second band and third band values */
556: ,nvl((sum(to_number(pact.action_information7))*100),0) tol_usc --12382953
557: FROM pay_assignment_actions paa
558: ,pay_action_information pact
559: ,pay_action_interlocks pai
560: WHERE paa.payroll_action_id = p_payroll_action_id
561: AND paa.source_action_id IS NULL
571: select count(decode(pact.action_information23,0,null,null,null,1)) EMP_PARKING,
572: TRUNC(SUM(to_number(pact.action_information23)))*100 EMP_PARKING_BAL ,
573: nvl((SUM(TRUNC(to_number(pact.action_information19)))*100),0) empr_income_band
574: ,nvl((SUM(TRUNC(to_number(pact.action_information7)))*100),0) tol_usc --12382953
575: FROM pay_assignment_actions paa
576: ,pay_action_information pact
577: ,pay_action_interlocks pai
578: WHERE paa.payroll_action_id = p_payroll_action_id
579: AND paa.source_action_id IS NULL