DBA Data[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on HR_LOCATIONS_ALL

Line 6442: from hr_locations_all

6438: -- Also, fix for the bug 4105698 is modified to make the cursor
6439: -- compatible with 8i.
6440: cursor csr_valid_location_upd is
6441: select inactive_date
6442: from hr_locations_all
6443: where location_id = p_location_id
6444: and (business_group_id= (
6445: select distinct business_group_id
6446: from per_all_assignments_f

Line 6453: from hr_locations_all

6449:
6450: -- bug 4318990 added an nvl in the where condition for relaxing the validation
6451: cursor csr_valid_location_ins is
6452: select inactive_date
6453: from hr_locations_all
6454: where location_id = p_location_id
6455: and (business_group_id= nvl(p_business_group_id,business_group_id) --Modified for bug 11063182 nvl(hr_general.get_business_group_id,business_group_id)
6456: or business_group_id is null);
6457: -- Bug 4116879 Ends