APPS.EGO_ITEM_LC_IMP_PC_PUB dependencies on EGO_LCPHASE_ITEM_STATUS

Line 1104: FROM ego_lcphase_item_status status, pa_proj_elements lc_phases

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

Line 1113: FROM ego_lcphase_item_status status, pa_ego_phases_v lc_phases

1109:
1110: CURSOR c_validate_status_code (cp_phase_id IN NUMBER
1111: ,cp_status_code IN VARCHAR2) IS
1112: SELECT status.item_status_code
1113: FROM ego_lcphase_item_status status, pa_ego_phases_v lc_phases
1114: WHERE lc_phases.proj_element_id = cp_phase_id
1115: AND status.phase_code = lc_phases.phase_code
1116: AND status.item_status_code = cp_status_code;
1117: --Bug 14076356 , Added to validate the Item status