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_DO_UPDATE dependencies on HR_ORGANIZATION_INFORMATION

Line 3376: FROM HR_ORGANIZATION_INFORMATION

3372: AND c_effective_date BETWEEN pos.effective_start_date and pos.effective_end_date;
3373:
3374: CURSOR get_segment(c_business_group_id per_people_f.business_group_id%type) IS
3375: SELECT ORG_INFORMATION5
3376: FROM HR_ORGANIZATION_INFORMATION
3377: WHERE ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_INFORMATION'
3378: AND ORGANIZATION_ID = c_business_group_id;
3379:
3380: l_agency_segment hr_organization_information.org_information5%type;

Line 3380: l_agency_segment hr_organization_information.org_information5%type;

3376: FROM HR_ORGANIZATION_INFORMATION
3377: WHERE ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_INFORMATION'
3378: AND ORGANIZATION_ID = c_business_group_id;
3379:
3380: l_agency_segment hr_organization_information.org_information5%type;
3381: l_pos_agency_code VARCHAR2(30);
3382:
3383: CURSOR c_get_agency_code(c_segment hr_organization_information.org_information5%type,
3384: c_position_id hr_all_positions_f.position_id%type,

Line 3383: CURSOR c_get_agency_code(c_segment hr_organization_information.org_information5%type,

3379:
3380: l_agency_segment hr_organization_information.org_information5%type;
3381: l_pos_agency_code VARCHAR2(30);
3382:
3383: CURSOR c_get_agency_code(c_segment hr_organization_information.org_information5%type,
3384: c_position_id hr_all_positions_f.position_id%type,
3385: c_effective_date hr_all_positions_f.effective_start_date%type) IS
3386: SELECT DECODE(c_segment,'SEGMENT1',SEGMENT1,
3387: 'SEGMENT2',SEGMENT2,