APPS.GHR_MLC_PKG dependencies on GHR_NATURE_OF_ACTIONS

Line 89: FROM ghr_nature_of_actions

85: WHERE NOA_FAMILY_CODE in
86: (SELECT NOA_FAMILY_CODE FROM ghr_noa_families
87: WHERE nature_of_action_id in
88: (SELECT nature_of_action_id
89: FROM ghr_nature_of_actions
90: WHERE code = nvl(ghr_msl_pkg.g_first_noa_code,'895') )
91: ) and proc_method_flag = 'Y';
92:
93: l_assignment_id per_assignments_f.assignment_id%type;

Line 1242: from ghr_nature_of_actions

1238: where NOA_FAMILY_CODE in
1239: (select NOA_FAMILY_CODE from ghr_noa_families
1240: where nature_of_action_id in
1241: (select nature_of_action_id
1242: from ghr_nature_of_actions
1243: where code = cnoacode)
1244: ) and proc_method_flag = 'Y';
1245:
1246: