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 189: (select NOA_FAMILY_CODE from ghr_noa_families

185: cursor get_sal_chg_fam is
186: select NOA_FAMILY_CODE
187: from ghr_families
188: where NOA_FAMILY_CODE in
189: (select NOA_FAMILY_CODE from ghr_noa_families
190: where nature_of_action_id =
191: (select nature_of_action_id
192: from ghr_nature_of_actions
193: where code = '894')

Line 5093: (select NOA_FAMILY_CODE from ghr_noa_families

5089: /*cursor get_sal_chg_fam is
5090: select NOA_FAMILY_CODE
5091: from ghr_families
5092: where NOA_FAMILY_CODE in
5093: (select NOA_FAMILY_CODE from ghr_noa_families
5094: where nature_of_action_id =
5095: (select nature_of_action_id
5096: from ghr_nature_of_actions
5097: where code = '894')

Line 5326: (select NOA_FAMILY_CODE from ghr_noa_families

5322: cursor get_sal_chg_fam is
5323: select NOA_FAMILY_CODE
5324: from ghr_families
5325: where NOA_FAMILY_CODE in
5326: (select NOA_FAMILY_CODE from ghr_noa_families
5327: where nature_of_action_id =
5328: (select nature_of_action_id
5329: from ghr_nature_of_actions
5330: where code = nvl(g_first_noa_code,'894') and g_effective_date between date_from and nvl(date_to,g_effective_date))

Line 7229: (select NOA_FAMILY_CODE from ghr_noa_families

7225: cursor get_sal_chg_fam is
7226: select NOA_FAMILY_CODE
7227: from ghr_families
7228: where NOA_FAMILY_CODE in
7229: (select NOA_FAMILY_CODE from ghr_noa_families
7230: where nature_of_action_id =
7231: (select nature_of_action_id
7232: from ghr_nature_of_actions
7233: where code = '890')