APPS.EGO_ITEM_LC_IMP_PC_PUB dependencies on PA_PROJ_ELEMENTS

Line 1101: FROM ego_lcphase_item_status status, pa_proj_elements lc_phases

1097: AND organization_id = cp_org_id;
1098:
1099: CURSOR c_get_def_status_code (cp_phase_id IN NUMBER) IS
1100: SELECT status.item_status_code
1101: FROM ego_lcphase_item_status status, pa_proj_elements lc_phases
1102: WHERE lc_phases.proj_element_id = cp_phase_id
1103: AND status.phase_code = lc_phases.phase_code
1104: AND status.default_flag = 'Y'
1105: AND lc_phases.PROJECT_ID = 0 AND lc_phases.OBJECT_TYPE = 'PA_TASKS';