APPS.PAY_PYUCSLIS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 496: FROM hr_all_organization_units org

492: p_request_id,
493: p_program_application_id,
494: p_program_id,
495: l_update_date
496: FROM hr_all_organization_units org
497: , per_organization_list lst
498: WHERE lst.security_profile_id = l_security_profile_id
499: AND lst.organization_id=org.organization_id
500: AND NOT EXISTS

Line 568: FROM hr_all_organization_units org

564: WHERE pol.security_profile_id = l_security_profile_id
565: AND pol.user_id IS NULL
566: AND pol.organization_id IN
567: (SELECT org.business_group_id
568: FROM hr_all_organization_units org
569: WHERE org.organization_id = pol.organization_id
570: AND org.organization_id = org.business_group_id);
571: --
572: END IF;