DBA Data[Home] [Help]

APPS.PA_TASK_WORKFLOW_PKG dependencies on HR_ORGANIZATION_UNITS

Line 461: FROM HR_ORGANIZATION_UNITS

457:
458: -- Cursor to fetch the name of the organization for the inputted organization_id
459: CURSOR c_orgz_info (p_carrying_out_organization_id NUMBER) IS
460: SELECT name organization_name
461: FROM HR_ORGANIZATION_UNITS
462: WHERE organization_id = p_carrying_out_organization_id;
463:
464: -- Cursor to fetch the change document information for the respective change document id
465: CURSOR c_ci_info IS