APPS.INV_EBI_ITEM_HELPER dependencies on EGO_LCPHASE_ITEM_STATUS

Line 1503: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;

1499: ************************************************************************************/
1500: FUNCTION Get_Default_Item_Status_Code(p_phase_id IN NUMBER)
1501: RETURN VARCHAR2 IS
1502:
1503: l_status_code EGO_LCPHASE_ITEM_STATUS.ITEM_STATUS_CODE%TYPE;
1504:
1505: BEGIN
1506:
1507: SELECT status.ITEM_STATUS_CODE INTO l_status_code

Line 1508: FROM EGO_LCPHASE_ITEM_STATUS status

1504:
1505: BEGIN
1506:
1507: SELECT status.ITEM_STATUS_CODE INTO l_status_code
1508: FROM EGO_LCPHASE_ITEM_STATUS status
1509: ,PA_EGO_PHASES_V phases
1510: WHERE phases.PROJ_ELEMENT_ID = p_phase_id
1511: AND status.PHASE_CODE = phases.PHASE_CODE
1512: AND DEFAULT_FLAG = 'Y';