DBA Data[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'