APPS.GHR_REI_BUS dependencies on PER_PEOPLE_F

Line 678: l_person_id per_people_f.person_id%type;

674: --
675: l_proc varchar2(72) := g_package||'insert_validate';
676: l_multiple_occurrences_flag ghr_pa_request_info_types.multiple_occurrences_flag%type;
677: --
678: l_person_id per_people_f.person_id%type;
679: l_position_id per_positions.position_id%type;
680: l_bus_group_id per_people_f.business_group_id%type;
681:
682: -- Bug#5729582 (i)added local variable l_effective_date

Line 680: l_bus_group_id per_people_f.business_group_id%type;

676: l_multiple_occurrences_flag ghr_pa_request_info_types.multiple_occurrences_flag%type;
677: --
678: l_person_id per_people_f.person_id%type;
679: l_position_id per_positions.position_id%type;
680: l_bus_group_id per_people_f.business_group_id%type;
681:
682: -- Bug#5729582 (i)added local variable l_effective_date
683: -- (ii) Modified the cursors c_get_perpos_ids,c_per_bus_group_id,c_pos_bus_group_id
684: l_effective_date ghr_pa_requests.effective_date%type;

Line 691: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE) is

687: select par.person_id,nvl(par.from_position_id,par.to_position_id) position_id,
688: par.effective_date
689: from ghr_pa_requests par
690: where pa_request_id = p_rec.pa_request_id;
691: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE) is
692: select ppf.business_group_id
693: from per_people_f ppf
694: where ppf.person_id = p_person_id
695: and l_effective_date between ppf.effective_start_date

Line 693: from per_people_f ppf

689: from ghr_pa_requests par
690: where pa_request_id = p_rec.pa_request_id;
691: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE) is
692: select ppf.business_group_id
693: from per_people_f ppf
694: where ppf.person_id = p_person_id
695: and l_effective_date between ppf.effective_start_date
696: and ppf.effective_end_date;
697: cursor c_pos_bus_group_id(p_position_id in per_positions.position_id%TYPE ) is

Line 920: l_person_id per_people_f.person_id%type;

916: Procedure update_validate(p_rec in ghr_rei_shd.g_rec_type) is
917: --
918: l_proc varchar2(72) := g_package||'update_validate';
919: --
920: l_person_id per_people_f.person_id%type;
921: l_position_id per_positions.position_id%type;
922: l_bus_group_id per_people_f.business_group_id%type;
923:
924: -- Bug#5729582 (i)added local variable l_effective_date

Line 922: l_bus_group_id per_people_f.business_group_id%type;

918: l_proc varchar2(72) := g_package||'update_validate';
919: --
920: l_person_id per_people_f.person_id%type;
921: l_position_id per_positions.position_id%type;
922: l_bus_group_id per_people_f.business_group_id%type;
923:
924: -- Bug#5729582 (i)added local variable l_effective_date
925: -- (ii) Modified the cursors c_get_perpos_ids,c_per_bus_group_id,c_pos_bus_group_id
926: l_effective_date ghr_pa_requests.effective_date%type;

Line 933: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE) is

929: select par.person_id,nvl(par.from_position_id,par.to_position_id) position_id,
930: par.effective_date
931: from ghr_pa_requests par
932: where pa_request_id = p_rec.pa_request_id;
933: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE) is
934: select ppf.business_group_id
935: from per_people_f ppf
936: where ppf.person_id = p_person_id
937: and l_effective_date between ppf.effective_start_date

Line 935: from per_people_f ppf

931: from ghr_pa_requests par
932: where pa_request_id = p_rec.pa_request_id;
933: cursor c_per_bus_group_id(p_person_id in per_people_f.person_id%TYPE) is
934: select ppf.business_group_id
935: from per_people_f ppf
936: where ppf.person_id = p_person_id
937: and l_effective_date between ppf.effective_start_date
938: and ppf.effective_end_date;
939: cursor c_pos_bus_group_id(p_position_id in per_positions.position_id%TYPE ) is