APPS.GHR_SF52_UPDATE dependencies on PER_ALL_PEOPLE_F

Line 452: l_bg_id per_all_people_f.business_group_id%type;

448: l_errbuf varchar2(2000);
449: l_retcode number;
450: l_amount_or_rate VARCHAR2(100);
451: l_opt_val number;
452: l_bg_id per_all_people_f.business_group_id%type;
453: l_temp_appt VARCHAR2(5);
454: l_warning boolean;
455: -- Cursors declaration
456: --

Line 457: Cursor c_bg_id(c_person_id per_all_people_f.person_id%type,

453: l_temp_appt VARCHAR2(5);
454: l_warning boolean;
455: -- Cursors declaration
456: --
457: Cursor c_bg_id(c_person_id per_all_people_f.person_id%type,
458: c_effective_date per_all_people_f.effective_start_date%type) is
459: select business_group_id bg_id
460: from per_all_people_f
461: where person_id = c_person_id

Line 458: c_effective_date per_all_people_f.effective_start_date%type) is

454: l_warning boolean;
455: -- Cursors declaration
456: --
457: Cursor c_bg_id(c_person_id per_all_people_f.person_id%type,
458: c_effective_date per_all_people_f.effective_start_date%type) is
459: select business_group_id bg_id
460: from per_all_people_f
461: where person_id = c_person_id
462: and c_effective_date between effective_start_date and effective_end_date;

Line 460: from per_all_people_f

456: --
457: Cursor c_bg_id(c_person_id per_all_people_f.person_id%type,
458: c_effective_date per_all_people_f.effective_start_date%type) is
459: select business_group_id bg_id
460: from per_all_people_f
461: where person_id = c_person_id
462: and c_effective_date between effective_start_date and effective_end_date;
463:
464: --Start of Bug # 5195518 added to check current enrollment