DBA Data[Home] [Help]

APPS.PER_ASG_BUS1 dependencies on HR_LOCATIONS_ALL

Line 6256: from hr_locations_all

6252: -- Also, fix for the bug 4105698 is modified to make the cursor
6253: -- compatible with 8i.
6254: cursor csr_valid_location_upd is
6255: select inactive_date
6256: from hr_locations_all
6257: where location_id = p_location_id
6258: and (business_group_id= (
6259: select distinct business_group_id
6260: from per_all_assignments_f

Line 6267: from hr_locations_all

6263:
6264: -- bug 4318990 added an nvl in the where condition for relaxing the validation
6265: cursor csr_valid_location_ins is
6266: select inactive_date
6267: from hr_locations_all
6268: where location_id = p_location_id
6269: and (business_group_id= nvl(hr_general.get_business_group_id,business_group_id)
6270: or business_group_id is null);
6271: -- Bug 4116879 Ends