APPS.GHR_MSL_PKG dependencies on GHR_NATURE_OF_ACTIONS

Line 188: from ghr_nature_of_actions

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')
190: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99
191: ------------- ) and update_hr_flag = 'Y';
192:

Line 5034: from ghr_nature_of_actions

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')
5036: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99 */
5037: ------------- ) and update_hr_flag = 'Y';
5038:

Line 5265: from ghr_nature_of_actions

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))
5267: ) and proc_method_flag = 'Y';
5268: --7577249
5269: l_ds_end_date ghr_duty_stations_f.effective_end_date%type;

Line 7086: from ghr_nature_of_actions

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')
7088: ) and proc_method_flag = 'Y'; --AVR 13-JAN-99
7089: ------------- ) and update_hr_flag = 'Y';
7090: