eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_SF52_UPDATE dependencies on PER_ALL_PEOPLE_F

Line 456: l_bg_id per_all_people_f.business_group_id%type;

452: l_errbuf varchar2(2000);
453: l_retcode number;
454: l_amount_or_rate VARCHAR2(100);
455: l_opt_val number;
456: l_bg_id per_all_people_f.business_group_id%type;
457: l_temp_appt VARCHAR2(5);
458: l_warning boolean;
459: -- Cursors declaration
460: --

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

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

Line 462: c_effective_date per_all_people_f.effective_start_date%type) is

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

Line 464: from per_all_people_f

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