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_PRE_UPDATE dependencies on GHR_PA_REQUEST_INFO_TYPES

Line 2261: l_information_type ghr_pa_request_info_types.information_type%type;

2257:
2258: l_proc varchar2(70) := 'Process_non_sf52_extra_info';
2259: l_noa_code ghr_nature_of_actions.code%type;
2260: l_noa_id ghr_nature_of_actions.nature_of_action_id%type;
2261: l_information_type ghr_pa_request_info_types.information_type%type;
2262: l_pa_request_ei_rec ghr_pa_request_extra_info%rowtype;
2263: p_extra_info_agency_rec ghr_api.extra_info_rec_type;
2264: l_session ghr_history_api.g_session_var_type;
2265: l_multiple_error_flag boolean;

Line 2274: from ghr_pa_request_info_types pit,

2270: --
2271: -- Bug#3941541 Added the effective date condition.
2272: Cursor c_info_types is
2273: Select pit.information_type
2274: from ghr_pa_request_info_types pit,
2275: ghr_noa_families nfa,
2276: ghr_families fam
2277: where nfa.nature_of_action_id = p_pa_request_rec.first_noa_id
2278: and nfa.noa_family_code = fam.noa_family_code