[Home] [Help]
APPS.PSP_LABOR_DIST dependencies on HR_ORGANIZATION_UNITS
Line 4003: FROM hr_organization_units hou,
3999: CURSOR org_name_cur(P_PAYROLL_START_DATE IN DATE,
4000: P_ASSIGNMENT_ID IN NUMBER) IS
4001: SELECT hou.organization_id,
4002: hou.name
4003: FROM hr_organization_units hou,
4004: per_assignments_f paf
4005: WHERE paf.business_group_id = p_business_group_id
4006: AND paf.assignment_id = p_assignment_id
4007: and paf.assignment_type = 'E'