[Home] [Help]
2597: , p_plan_year_end_date date
2598: , p_legal_entity_id number) is
2599: select ppf.person_id
2600: , paa.assignment_id
2601: from per_all_people_f ppf
2602: , per_all_assignments_f paa
2603: , per_assignment_extra_info paei
2604: , pay_payroll_actions ppa_arch
2605: , per_periods_of_service pps
2615: and paei.aei_information_category = 'ZA_SPECIFIC_INFO'
2616: and paei.aei_information7 = p_legal_entity_id -- support archive for one or all legal entities in that bg
2617: -- check if the person is active within the training and plan year
2618: and ppf.effective_start_date = ( select max(effective_start_date)
2619: from per_all_people_f ppf1
2620: where ppf1.person_id = ppf.person_id
2621: and ppf1.effective_start_date <= g_wsp_end_date
2622: and ppf1.effective_end_date >= g_atr_start_date
2623: )
2859: *****************************************************************************/
2860: procedure archive_wsp_data2( assactid in number
2861: , p_person_id in per_all_assignments_f.person_id%type
2862: , p_assignment_id in per_all_assignments_f.assignment_id%type
2863: , p_race in per_all_people_f.per_information4%type
2864: , p_sex in per_all_people_f.sex%type
2865: , p_ass_cat_name in hr_lookups.meaning%type
2866: , p_skills_pri_id in number
2867: , p_trng_event_id in number
2860: procedure archive_wsp_data2( assactid in number
2861: , p_person_id in per_all_assignments_f.person_id%type
2862: , p_assignment_id in per_all_assignments_f.assignment_id%type
2863: , p_race in per_all_people_f.per_information4%type
2864: , p_sex in per_all_people_f.sex%type
2865: , p_ass_cat_name in hr_lookups.meaning%type
2866: , p_skills_pri_id in number
2867: , p_trng_event_id in number
2868: , p_trng_event_name in varchar2
2937: *****************************************************************************/
2938: procedure archive_wsp_data( assactid in number
2939: , p_person_id in per_all_assignments_f.person_id%type
2940: , p_assignment_id in per_all_assignments_f.assignment_id%type
2941: , p_race in per_all_people_f.per_information4%type
2942: , p_sex in per_all_people_f.sex%type
2943: , p_ass_cat_name in hr_lookups.meaning%type
2944: , p_legal_entity_id in number
2945: , p_disability in varchar2
2938: procedure archive_wsp_data( assactid in number
2939: , p_person_id in per_all_assignments_f.person_id%type
2940: , p_assignment_id in per_all_assignments_f.assignment_id%type
2941: , p_race in per_all_people_f.per_information4%type
2942: , p_sex in per_all_people_f.sex%type
2943: , p_ass_cat_name in hr_lookups.meaning%type
2944: , p_legal_entity_id in number
2945: , p_disability in varchar2
2946: ) is
3474: *****************************************************************************/
3475: procedure archive_atr_data2( assactid in number
3476: , p_person_id in per_all_assignments_f.person_id%type
3477: , p_assignment_id in per_all_assignments_f.assignment_id%type
3478: , p_race in per_all_people_f.per_information4%type
3479: , p_sex in per_all_people_f.sex%type
3480: , p_ass_cat_name in hr_lookups.meaning%type
3481: , p_skills_pri_id in number
3482: , p_trng_event_id in number
3475: procedure archive_atr_data2( assactid in number
3476: , p_person_id in per_all_assignments_f.person_id%type
3477: , p_assignment_id in per_all_assignments_f.assignment_id%type
3478: , p_race in per_all_people_f.per_information4%type
3479: , p_sex in per_all_people_f.sex%type
3480: , p_ass_cat_name in hr_lookups.meaning%type
3481: , p_skills_pri_id in number
3482: , p_trng_event_id in number
3483: , p_trng_event_name in varchar2
3558: *****************************************************************************/
3559: procedure archive_atr_data( assactid in number
3560: , p_person_id in per_all_assignments_f.person_id%type
3561: , p_assignment_id in per_all_assignments_f.assignment_id%type
3562: , p_race in per_all_people_f.per_information4%type
3563: , p_sex in per_all_people_f.sex%type
3564: , p_ass_cat_name in hr_lookups.meaning%type
3565: , p_legal_entity_id in number
3566: , p_disability in varchar2
3559: procedure archive_atr_data( assactid in number
3560: , p_person_id in per_all_assignments_f.person_id%type
3561: , p_assignment_id in per_all_assignments_f.assignment_id%type
3562: , p_race in per_all_people_f.per_information4%type
3563: , p_sex in per_all_people_f.sex%type
3564: , p_ass_cat_name in hr_lookups.meaning%type
3565: , p_legal_entity_id in number
3566: , p_disability in varchar2
3567: ) is
4147: l_proc varchar2(50);
4148: l_assignment_id per_all_assignments_f.assignment_id%type;
4149: l_person_id per_all_assignments_f.person_id%type;
4150: l_ass_cat_name hr_lookups.meaning%type;
4151: l_race per_all_people_f.per_information4%type;
4152: l_sex per_all_people_f.sex%type;
4153: l_legal_entity_id number(30);
4154: l_disability varchar2(30);
4155:
4148: l_assignment_id per_all_assignments_f.assignment_id%type;
4149: l_person_id per_all_assignments_f.person_id%type;
4150: l_ass_cat_name hr_lookups.meaning%type;
4151: l_race per_all_people_f.per_information4%type;
4152: l_sex per_all_people_f.sex%type;
4153: l_legal_entity_id number(30);
4154: l_disability varchar2(30);
4155:
4156: begin
4182: , l_legal_entity_id
4183: , l_ass_cat_name
4184: From per_all_assignments_f paaf
4185: , pay_assignment_actions paa
4186: , per_all_people_f perf
4187: , per_assignment_extra_info paei
4188: Where paa.assignment_action_id = p_assactid
4189: and paa.assignment_id = paaf.assignment_id
4190: and paaf.person_id = perf.person_id