[Home] [Help]
280: l_package varchar2(80) := g_package||'.run_rule';
281: l_result number;
282: l_outputs ff_exec.outputs_t;
283: l_loc_rec hr_locations_all%rowtype;
284: l_ass_rec per_all_assignments_f%rowtype;
285: l_pil_rec ben_per_in_ler%rowtype;
286: l_pl_rec ben_pl_f%rowtype;
287: l_oipl_rec ben_oipl_f%rowtype;
288: l_jurisdiction_code varchar2(30);
489: asg.assignment_id,
490: ppp.change_date -- Bug:3265142. Added this for order-by clause
491: from per_pay_proposals ppp,
492: -- per_assignments_f asg,
493: per_all_assignments_f asg,
494: per_pay_bases ppb,
495: pay_all_payrolls_f paf,
496: per_all_people_f per
497: where per.person_id = p_person_id
539: asg.frequency,
540: asg.assignment_id assignment_id,
541: fnd_date.canonical_to_date(aei.aei_information8) change_date
542: from --per_assignments_f asg,
543: per_all_assignments_f asg,
544: per_assignment_extra_info aei,
545: per_pay_bases ppb,
546: pay_all_payrolls_f paf,
547: per_all_people_f per
561: --and l_date <= asg.effective_end_date
562: and l_date between per.effective_start_date and per.effective_end_date
563: and asg.assignment_id = aei.assignment_id
564: and not exists (select 1
565: from per_all_assignments_f asg,
566: per_all_people_f per
567: where per.person_id = p_person_id
568: and asg.assignment_type = 'E'
569: and asg.person_id = per.person_id
652: l_person_balance c_person_balance%rowtype;
653: --
654: cursor c_assignment is
655: select assignment_id
656: from per_all_assignments_f paf
657: where primary_flag = 'Y'
658: and person_id = p_person_id
659: and paf.assignment_type <> 'C'
660: and business_group_id = p_business_group_id
664: order by decode(paf.assignment_type, 'E',1,2);
665:
666: Cursor c_ass is
667: select min(effective_start_date)
668: From per_all_assignments_f ass
669: where person_id = p_person_id
670: and ass.assignment_type <> 'C'
671: and primary_flag = 'Y' ;
672:
674: Cursor c_ass_after_detdt is
675: --Start Bug 14456969: Modified the cursor conditions to identify Ex-Emp Rehire
676: SELECT min (ass.effective_start_date)
677: FROM per_all_people_f per
678: , per_all_assignments_f ass
679: WHERE per.person_id = p_person_id
680: AND per.person_id = ass.person_id
681: AND per.current_employee_flag = 'Y'
682: AND ass.assignment_type NOT IN ('B', 'C')
691: --Start Bug 14456969: Modified the cursor conditions to identify Ex-Emp Rehire
692: Cursor c_exists_ass_as_of_detdt is
693: SELECT 1
694: FROM per_all_people_f per
695: , per_all_assignments_f ass
696: WHERE per.person_id = p_person_id
697: AND per.person_id = ass.person_id
698: AND per.current_employee_flag = 'Y'
699: AND ass.assignment_type NOT IN ('B', 'C')
1925: l_per c_per%rowtype;
1926: --
1927: cursor c_per_extra (p_person_id in number) is
1928: select aei.aei_information1
1929: from per_all_assignments_f asg,
1930: per_assignment_extra_info aei
1931: where asg.person_id = p_person_id
1932: and asg.assignment_id = aei.assignment_id
1933: and asg.primary_flag = 'Y'
2437: cursor c_person_extra is
2438: select aei.aei_information2 iasd,
2439: aei.aei_information13 idoh,
2440: aei.aei_information3 iohd
2441: from per_all_assignments_f asg,
2442: per_assignment_extra_info aei
2443: where asg.person_id = p_person_id
2444: and asg.assignment_id = aei.assignment_id
2445: and asg.primary_flag = 'Y'
2894: l_effective_date date ;
2895:
2896: cursor c_ass is
2897: select min(effective_start_date)
2898: from per_all_assignments_f ass
2899: where person_id = p_person_id
2900: and (assignment_id = p_assignment_id or
2901: (p_assignment_id is null and
2902: ass.primary_flag = 'Y' and
2903: ass.assignment_type <> 'C'));
2904:
2905: cursor c_assignment is
2906: select assignment_id
2907: from per_all_assignments_f paf
2908: where person_id = p_person_id
2909: and (assignment_id = p_assignment_id or
2910: (p_assignment_id is null and
2911: primary_flag = 'Y' and
3224: l_effective_date date ;
3225:
3226: cursor c_assignment is
3227: select assignment_id
3228: from per_all_assignments_f paf
3229: where primary_flag = 'Y'
3230: and person_id = p_person_id
3231: and paf.assignment_type <> 'C'
3232: and business_group_id = p_business_group_id