[Home] [Help]
2591: , p_plan_year_end_date date
2592: , p_legal_entity_id number) is
2593: select ppf.person_id
2594: , paa.assignment_id
2595: from per_all_people_f ppf
2596: , per_all_assignments_f paa
2597: , per_assignment_extra_info paei
2598: , pay_payroll_actions ppa_arch
2599: , per_periods_of_service pps
2609: and paei.aei_information_category = 'ZA_SPECIFIC_INFO'
2610: and paei.aei_information7 = p_legal_entity_id -- support archive for one or all legal entities in that bg
2611: -- check if the person is active within the training and plan year
2612: and ppf.effective_start_date = ( select max(effective_start_date)
2613: from per_all_people_f ppf1
2614: where ppf1.person_id = ppf.person_id
2615: and ppf1.effective_start_date <= g_wsp_end_date
2616: and ppf1.effective_end_date >= g_atr_start_date
2617: )
2853: *****************************************************************************/
2854: procedure archive_wsp_data2( assactid in number
2855: , p_person_id in per_all_assignments_f.person_id%type
2856: , p_assignment_id in per_all_assignments_f.assignment_id%type
2857: , p_race in per_all_people_f.per_information4%type
2858: , p_sex in per_all_people_f.sex%type
2859: , p_ass_cat_name in hr_lookups.meaning%type
2860: , p_skills_pri_id in number
2861: , p_trng_event_id in number
2854: procedure archive_wsp_data2( assactid in number
2855: , p_person_id in per_all_assignments_f.person_id%type
2856: , p_assignment_id in per_all_assignments_f.assignment_id%type
2857: , p_race in per_all_people_f.per_information4%type
2858: , p_sex in per_all_people_f.sex%type
2859: , p_ass_cat_name in hr_lookups.meaning%type
2860: , p_skills_pri_id in number
2861: , p_trng_event_id in number
2862: , p_trng_event_name in varchar2
2931: *****************************************************************************/
2932: procedure archive_wsp_data( assactid in number
2933: , p_person_id in per_all_assignments_f.person_id%type
2934: , p_assignment_id in per_all_assignments_f.assignment_id%type
2935: , p_race in per_all_people_f.per_information4%type
2936: , p_sex in per_all_people_f.sex%type
2937: , p_ass_cat_name in hr_lookups.meaning%type
2938: , p_legal_entity_id in number
2939: , p_disability in varchar2
2932: procedure archive_wsp_data( assactid in number
2933: , p_person_id in per_all_assignments_f.person_id%type
2934: , p_assignment_id in per_all_assignments_f.assignment_id%type
2935: , p_race in per_all_people_f.per_information4%type
2936: , p_sex in per_all_people_f.sex%type
2937: , p_ass_cat_name in hr_lookups.meaning%type
2938: , p_legal_entity_id in number
2939: , p_disability in varchar2
2940: ) is
3468: *****************************************************************************/
3469: procedure archive_atr_data2( assactid in number
3470: , p_person_id in per_all_assignments_f.person_id%type
3471: , p_assignment_id in per_all_assignments_f.assignment_id%type
3472: , p_race in per_all_people_f.per_information4%type
3473: , p_sex in per_all_people_f.sex%type
3474: , p_ass_cat_name in hr_lookups.meaning%type
3475: , p_skills_pri_id in number
3476: , p_trng_event_id in number
3469: procedure archive_atr_data2( assactid in number
3470: , p_person_id in per_all_assignments_f.person_id%type
3471: , p_assignment_id in per_all_assignments_f.assignment_id%type
3472: , p_race in per_all_people_f.per_information4%type
3473: , p_sex in per_all_people_f.sex%type
3474: , p_ass_cat_name in hr_lookups.meaning%type
3475: , p_skills_pri_id in number
3476: , p_trng_event_id in number
3477: , p_trng_event_name in varchar2
3552: *****************************************************************************/
3553: procedure archive_atr_data( assactid in number
3554: , p_person_id in per_all_assignments_f.person_id%type
3555: , p_assignment_id in per_all_assignments_f.assignment_id%type
3556: , p_race in per_all_people_f.per_information4%type
3557: , p_sex in per_all_people_f.sex%type
3558: , p_ass_cat_name in hr_lookups.meaning%type
3559: , p_legal_entity_id in number
3560: , p_disability in varchar2
3553: procedure archive_atr_data( assactid in number
3554: , p_person_id in per_all_assignments_f.person_id%type
3555: , p_assignment_id in per_all_assignments_f.assignment_id%type
3556: , p_race in per_all_people_f.per_information4%type
3557: , p_sex in per_all_people_f.sex%type
3558: , p_ass_cat_name in hr_lookups.meaning%type
3559: , p_legal_entity_id in number
3560: , p_disability in varchar2
3561: ) is
4141: l_proc varchar2(50);
4142: l_assignment_id per_all_assignments_f.assignment_id%type;
4143: l_person_id per_all_assignments_f.person_id%type;
4144: l_ass_cat_name hr_lookups.meaning%type;
4145: l_race per_all_people_f.per_information4%type;
4146: l_sex per_all_people_f.sex%type;
4147: l_legal_entity_id number(30);
4148: l_disability varchar2(30);
4149:
4142: l_assignment_id per_all_assignments_f.assignment_id%type;
4143: l_person_id per_all_assignments_f.person_id%type;
4144: l_ass_cat_name hr_lookups.meaning%type;
4145: l_race per_all_people_f.per_information4%type;
4146: l_sex per_all_people_f.sex%type;
4147: l_legal_entity_id number(30);
4148: l_disability varchar2(30);
4149:
4150: begin
4176: , l_legal_entity_id
4177: , l_ass_cat_name
4178: From per_all_assignments_f paaf
4179: , pay_assignment_actions paa
4180: , per_all_people_f perf
4181: , per_assignment_extra_info paei
4182: Where paa.assignment_action_id = p_assactid
4183: and paa.assignment_id = paaf.assignment_id
4184: and paaf.person_id = perf.person_id