DBA Data[Home] [Help]

APPS.GHR_MASS_CHANGES dependencies on GHR_NATURE_OF_ACTIONS

Line 110: from ghr_nature_of_actions

106: where NOA_FAMILY_CODE in
107: (select NOA_FAMILY_CODE from ghr_noa_families
108: where nature_of_action_id =
109: (select nature_of_action_id
110: from ghr_nature_of_actions
111: where code = '894')
112: ) and proc_method_flag = 'Y';
113:
114: Cursor c_routing_history is

Line 129: from ghr_nature_of_actions

125: where NOA_FAMILY_CODE in
126: (select NOA_FAMILY_CODE from ghr_noa_families
127: where nature_of_action_id =
128: (select nature_of_action_id
129: from ghr_nature_of_actions
130: where code = nvl(ghr_msl_pkg.g_first_noa_code,'894') and p_effective_date between date_from and nvl(date_to,p_effective_date))
131: ) and proc_method_flag = 'Y';
132: ----7577249
133: