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_MSL_PKG dependencies on GHR_NOA_FAMILIES

Line 185: (select NOA_FAMILY_CODE from ghr_noa_families

181: cursor get_sal_chg_fam is
182: select NOA_FAMILY_CODE
183: from ghr_families
184: where NOA_FAMILY_CODE in
185: (select NOA_FAMILY_CODE from ghr_noa_families
186: where nature_of_action_id =
187: (select nature_of_action_id
188: from ghr_nature_of_actions
189: where code = '894')

Line 5031: (select NOA_FAMILY_CODE from ghr_noa_families

5027: /*cursor get_sal_chg_fam is
5028: select NOA_FAMILY_CODE
5029: from ghr_families
5030: where NOA_FAMILY_CODE in
5031: (select NOA_FAMILY_CODE from ghr_noa_families
5032: where nature_of_action_id =
5033: (select nature_of_action_id
5034: from ghr_nature_of_actions
5035: where code = '894')

Line 5262: (select NOA_FAMILY_CODE from ghr_noa_families

5258: cursor get_sal_chg_fam is
5259: select NOA_FAMILY_CODE
5260: from ghr_families
5261: where NOA_FAMILY_CODE in
5262: (select NOA_FAMILY_CODE from ghr_noa_families
5263: where nature_of_action_id =
5264: (select nature_of_action_id
5265: from ghr_nature_of_actions
5266: where code = nvl(g_first_noa_code,'894') and g_effective_date between date_from and nvl(date_to,g_effective_date))

Line 7083: (select NOA_FAMILY_CODE from ghr_noa_families

7079: cursor get_sal_chg_fam is
7080: select NOA_FAMILY_CODE
7081: from ghr_families
7082: where NOA_FAMILY_CODE in
7083: (select NOA_FAMILY_CODE from ghr_noa_families
7084: where nature_of_action_id =
7085: (select nature_of_action_id
7086: from ghr_nature_of_actions
7087: where code = '890')