APPS.HR_IT_EXTRA_PERSON_RULES dependencies on HR_ORGANIZATION_UNITS

Line 163: ,hr_organization_units org

159: ,p_collective_agreement_id NUMBER
160: ,p_organization_id NUMBER) IS
161: SELECT pcagv.dynamic_insert_allowed
162: FROM per_coll_agree_grades_v pcagv
163: ,hr_organization_units org
164: WHERE org.organization_id = p_organization_id
165: AND pcagv.business_group_id = org.business_group_id
166: AND pcagv.collective_agreement_id = p_collective_agreement_id
167: AND pcagv.id_flex_num = p_cagr_id_flex_num