DBA Data[Home] [Help]

APPS.GHR_MASS_CHANGES dependencies on GHR_NATURE_OF_ACTIONS

Line 120: from ghr_nature_of_actions

116: where NOA_FAMILY_CODE in
117: (select NOA_FAMILY_CODE from ghr_noa_families
118: where nature_of_action_id =
119: (select nature_of_action_id
120: from ghr_nature_of_actions
121: where code = '894'
122: and p_effective_date between date_from and nvl(date_to,p_effective_date) )
123: ) and proc_method_flag = 'Y';
124:

Line 140: from ghr_nature_of_actions

136: where NOA_FAMILY_CODE in
137: (select NOA_FAMILY_CODE from ghr_noa_families
138: where nature_of_action_id =
139: (select nature_of_action_id
140: from ghr_nature_of_actions
141: 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))
142: ) and proc_method_flag = 'Y';
143: ----7577249
144: