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_NOA_FAMILIES

Line 107: (select NOA_FAMILY_CODE from ghr_noa_families

103: cursor get_sal_chg_fam is
104: select NOA_FAMILY_CODE
105: from ghr_families
106: where NOA_FAMILY_CODE in
107: (select NOA_FAMILY_CODE from ghr_noa_families
108: where nature_of_action_id =
109: (select nature_of_action_id
110: from ghr_nature_of_actions
111: where code = '894')

Line 126: (select NOA_FAMILY_CODE from ghr_noa_families

122: cursor get_family_code(p_effective_date in date) is
123: select NOA_FAMILY_CODE
124: from ghr_families
125: where NOA_FAMILY_CODE in
126: (select NOA_FAMILY_CODE from ghr_noa_families
127: where nature_of_action_id =
128: (select nature_of_action_id
129: from ghr_nature_of_actions
130: where code = nvl(ghr_msl_pkg.g_first_noa_code,'894') and p_effective_date between date_from and nvl(date_to,p_effective_date))