APPS.GHR_VALIDATE_CHECK dependencies on GHR_NOAC_LAS

Line 161: from ghr_noac_las nla

157: --Begin Bug# 7501214. added the SUBSTR condition for lac_lookup_code for all the 4 cursors
158: -- to avoid the error while checking the LAC codes which are duplicated. Like VWN and VWN1 etc.
159: cursor c_first_la_code1 is
160: select 1
161: from ghr_noac_las nla
162: where nla.nature_of_action_id = p_pa_request_rec.first_noa_id
163: and SUBSTR(nla.lac_lookup_code,1,3) = p_pa_request_rec.first_action_la_code1
164: and nla.valid_first_lac_flag = 'Y'
165: and nvl(p_pa_request_rec.effective_date,trunc(sysdate))

Line 171: from ghr_noac_las nla

167: and nvl(nla.date_to,nvl(p_pa_request_rec.effective_date,trunc(sysdate)));
168:
169: cursor c_first_la_code2 is
170: select 1
171: from ghr_noac_las nla
172: where nla.nature_of_action_id = p_pa_request_rec.first_noa_id
173: and SUBSTR(nla.lac_lookup_code,1,3) = p_pa_request_rec.first_action_la_code2
174: and nla.valid_second_lac_flag = 'Y'
175: and nvl(p_pa_request_rec.effective_date,trunc(sysdate))

Line 181: from ghr_noac_las nla

177: and nvl(nla.date_to,nvl(p_pa_request_rec.effective_date,trunc(sysdate)));
178:
179: cursor c_second_la_code1 is
180: select 1
181: from ghr_noac_las nla
182: where nla.nature_of_action_id = p_pa_request_rec.second_noa_id
183: and SUBSTR(nla.lac_lookup_code,1,3) = p_pa_request_rec.second_action_la_code1
184: and nla.valid_first_lac_flag = 'Y'
185: and nvl(p_pa_request_rec.effective_date,trunc(sysdate))

Line 191: from ghr_noac_las nla

187: and nvl(nla.date_to,nvl(p_pa_request_rec.effective_date,trunc(sysdate)));
188:
189: cursor c_second_la_code2 is
190: select 1
191: from ghr_noac_las nla
192: where nla.nature_of_action_id = p_pa_request_rec.second_noa_id
193: and SUBSTR(nla.lac_lookup_code,1,3) = p_pa_request_rec.second_action_la_code2
194: and nla.valid_second_lac_flag = 'Y'
195: and nvl(p_pa_request_rec.effective_date,trunc(sysdate))