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_MASS_CHANGES dependencies on GHR_FAMILIES

Line 69: l_noa_family_code ghr_families.noa_family_code%type;

65: l_duty_station_desc ghr_duty_stations_v.duty_station_desc%TYPE;
66: l_appropriation_code1 varchar2(30);
67: l_appropriation_code2 varchar2(30);
68: l_position_id hr_positions_f.position_id%TYPE;
69: l_noa_family_code ghr_families.noa_family_code%type;
70: -- Bug#4256022 Declared the variable l_desc_out
71: l_desc_out ghr_pa_requests.first_noa_desc%TYPE;
72:
73: l_pa_request_num_prefix varchar2(10);

Line 115: from ghr_families

111: select userenv('sessionid') sesid from dual;
112:
113: cursor get_sal_chg_fam(p_effective_date in date) is
114: select NOA_FAMILY_CODE
115: from ghr_families
116: where NOA_FAMILY_CODE in
117: (select NOA_FAMILY_CODE from ghr_noa_families
118: where nature_of_action_id =
119: (select nature_of_action_id

Line 135: from ghr_families

131:
132: --7577249
133: cursor get_family_code(p_effective_date in date) is
134: select NOA_FAMILY_CODE
135: from ghr_families
136: where NOA_FAMILY_CODE in
137: (select NOA_FAMILY_CODE from ghr_noa_families
138: where nature_of_action_id =
139: (select nature_of_action_id