[Home] [Help]
265: l_package varchar2(80) := g_package||'.run_rule';
266: l_result number;
267: l_outputs ff_exec.outputs_t;
268: l_loc_rec hr_locations_all%rowtype;
269: l_ass_rec per_all_assignments_f%rowtype;
270: l_pil_rec ben_per_in_ler%rowtype;
271: l_pl_rec ben_pl_f%rowtype;
272: l_oipl_rec ben_oipl_f%rowtype;
273: l_jurisdiction_code varchar2(30);
474: asg.assignment_id,
475: ppp.change_date -- Bug:3265142. Added this for order-by clause
476: from per_pay_proposals ppp,
477: -- per_assignments_f asg,
478: per_all_assignments_f asg,
479: per_pay_bases ppb,
480: pay_all_payrolls_f paf,
481: per_all_people_f per
482: where per.person_id = p_person_id
524: asg.frequency,
525: asg.assignment_id assignment_id,
526: fnd_date.canonical_to_date(aei.aei_information8) change_date
527: from --per_assignments_f asg,
528: per_all_assignments_f asg,
529: per_assignment_extra_info aei,
530: per_pay_bases ppb,
531: pay_all_payrolls_f paf,
532: per_all_people_f per
546: --and l_date <= asg.effective_end_date
547: and l_date between per.effective_start_date and per.effective_end_date
548: and asg.assignment_id = aei.assignment_id
549: and not exists (select 1
550: from per_all_assignments_f asg,
551: per_all_people_f per
552: where per.person_id = p_person_id
553: and asg.assignment_type = 'E'
554: and asg.person_id = per.person_id
637: l_person_balance c_person_balance%rowtype;
638: --
639: cursor c_assignment is
640: select assignment_id
641: from per_all_assignments_f paf
642: where primary_flag = 'Y'
643: and person_id = p_person_id
644: and paf.assignment_type <> 'C'
645: and business_group_id = p_business_group_id
649: order by decode(paf.assignment_type, 'E',1,2);
650:
651: Cursor c_ass is
652: select min(effective_start_date)
653: From per_all_assignments_f ass
654: where person_id = p_person_id
655: and ass.assignment_type <> 'C'
656: and primary_flag = 'Y' ;
657:
657:
658: -- 3752197
659: Cursor c_ass_after_detdt is
660: select min(effective_start_date)
661: From per_all_assignments_f ass
662: where person_id = p_person_id
663: and ass.assignment_type <> 'C'
664: and primary_flag = 'Y'
665: and effective_start_Date >= l_date;
1807: l_per c_per%rowtype;
1808: --
1809: cursor c_per_extra (p_person_id in number) is
1810: select aei.aei_information1
1811: from per_all_assignments_f asg,
1812: per_assignment_extra_info aei
1813: where asg.person_id = p_person_id
1814: and asg.assignment_id = aei.assignment_id
1815: and asg.primary_flag = 'Y'
2317: cursor c_person_extra is
2318: select aei.aei_information2 iasd,
2319: aei.aei_information13 idoh,
2320: aei.aei_information3 iohd
2321: from per_all_assignments_f asg,
2322: per_assignment_extra_info aei
2323: where asg.person_id = p_person_id
2324: and asg.assignment_id = aei.assignment_id
2325: and asg.primary_flag = 'Y'
2773: l_effective_date date ;
2774:
2775: cursor c_ass is
2776: select min(effective_start_date)
2777: from per_all_assignments_f ass
2778: where person_id = p_person_id
2779: and (assignment_id = p_assignment_id or
2780: (p_assignment_id is null and
2781: ass.primary_flag = 'Y' and
2782: ass.assignment_type <> 'C'));
2783:
2784: cursor c_assignment is
2785: select assignment_id
2786: from per_all_assignments_f paf
2787: where person_id = p_person_id
2788: and (assignment_id = p_assignment_id or
2789: (p_assignment_id is null and
2790: primary_flag = 'Y' and
3103: l_effective_date date ;
3104:
3105: cursor c_assignment is
3106: select assignment_id
3107: from per_all_assignments_f paf
3108: where primary_flag = 'Y'
3109: and person_id = p_person_id
3110: and paf.assignment_type <> 'C'
3111: and business_group_id = p_business_group_id