APPS.GHR_MLC_PKG dependencies on GHR_NATURE_OF_ACTIONS

Line 87: FROM ghr_nature_of_actions

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

Line 1218: from ghr_nature_of_actions

1214: where NOA_FAMILY_CODE in
1215: (select NOA_FAMILY_CODE from ghr_noa_families
1216: where nature_of_action_id in
1217: (select nature_of_action_id
1218: from ghr_nature_of_actions
1219: where code = cnoacode)
1220: ) and proc_method_flag = 'Y';
1221:
1222: