APPS.GHR_MSL_PKG dependencies on GHR_NATURE_OF_ACTIONS

Line 192: from ghr_nature_of_actions

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')
194: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99
195: ------------- ) and update_hr_flag = 'Y';
196:

Line 5096: from ghr_nature_of_actions

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')
5098: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99 */
5099: ------------- ) and update_hr_flag = 'Y';
5100:

Line 5329: from ghr_nature_of_actions

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))
5331: ) and proc_method_flag = 'Y';
5332: --7577249
5333: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

Line 7232: from ghr_nature_of_actions

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')
7234: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99
7235: ------------- ) and update_hr_flag = 'Y';
7236: