APPS.HR_DISCOVERER dependencies on HR_BIS

Line 166: NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id); /* changed for bug 3294224 */

162: )
163: AND ass1.assignment_type = 'E'
164: )
165: AND ass.business_group_id+0=
166: NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id); /* changed for bug 3294224 */
167: --
168: -- checking for organization changes
169: --
170: SELECT MAX(cass.effective_end_date+1)

Line 206: NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id); /* changed for bug 3294224 */

202: )
203: AND ass1.assignment_type = 'E'
204: )
205: AND ass.business_group_id+0=
206: NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id); /* changed for bug 3294224 */
207: --
208: -- checking for job changes
209: --
210: SELECT MAX(cass.effective_end_date+1)

Line 247: NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id); /* changed for bug 3294224 */

243: )
244: AND ass1.assignment_type = 'E'
245: )
246: AND ass.business_group_id+0=
247: NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id); /* changed for bug 3294224 */
248: --
249: -- checking for position changes
250: --
251: SELECT MAX(cass.effective_end_date+1)

Line 287: NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id); /* changed for bug 3294224 */

283: )
284: AND ass1.assignment_type = 'E'
285: )
286: AND ass.business_group_id+0=
287: NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id); /* changed for bug 3294224 */
288: --
289: -- checking for grade changes
290: --
291: SELECT MAX(cass.effective_end_date+1)

Line 328: NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id); /* changed for bug 3294224 */

324: )
325: AND ass1.assignment_type = 'E'
326: )
327: AND ass.business_group_id+0=
328: NVL(hr_bis.get_sec_profile_bg_id, ass.business_group_id); /* changed for bug 3294224 */
329: --
330: -- checking for location changes
331: --
332: SELECT MAX(cass.effective_end_date+1)