APPS.PAY_PYUCSLIS_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 560: FROM hr_all_organization_units org

556: p_request_id,
557: p_program_application_id,
558: p_program_id,
559: l_update_date
560: FROM hr_all_organization_units org
561: , per_organization_list lst
562: WHERE lst.security_profile_id = l_security_profile_id
563: AND lst.organization_id=org.organization_id
564: AND NOT EXISTS

Line 632: FROM hr_all_organization_units org

628: WHERE pol.security_profile_id = l_security_profile_id
629: AND pol.user_id IS NULL
630: AND pol.organization_id IN
631: (SELECT org.business_group_id
632: FROM hr_all_organization_units org
633: WHERE org.organization_id = pol.organization_id
634: AND org.organization_id = org.business_group_id);
635: --
636: END IF;