DBA Data[Home] [Help]

APPS.EGO_PUB_FWK_PK dependencies on MTL_ITEM_CATALOG_GROUPS_B

Line 2453: from MTL_ITEM_CATALOG_GROUPS_B icc, EGO_MTL_CATALOG_GRP_VERS_B icc_ver

2449: elsif (p_batch_type = C_BATCH_ENTITY_ICC) then
2450: begin
2451: if (l_pk2_value <> -1) then
2452: select icc.ITEM_CATALOG_GROUP_ID into l_entity_id
2453: from MTL_ITEM_CATALOG_GROUPS_B icc, EGO_MTL_CATALOG_GRP_VERS_B icc_ver
2454: where icc.ITEM_CATALOG_GROUP_ID = icc_ver.ITEM_CATALOG_GROUP_ID
2455: and icc.ITEM_CATALOG_GROUP_ID = l_pk1_value
2456: and icc_ver.VERSION_SEQ_ID = l_pk2_value
2457: and SYSDATE BETWEEN NVL(icc.START_DATE_ACTIVE, SYSDATE) and NVL(icc.END_DATE_ACTIVE, SYSDATE);

Line 2461: from MTL_ITEM_CATALOG_GROUPS_B icc

2457: and SYSDATE BETWEEN NVL(icc.START_DATE_ACTIVE, SYSDATE) and NVL(icc.END_DATE_ACTIVE, SYSDATE);
2458: -- pk2_value version_id
2459: else
2460: select icc.ITEM_CATALOG_GROUP_ID into l_entity_id
2461: from MTL_ITEM_CATALOG_GROUPS_B icc
2462: where icc.ITEM_CATALOG_GROUP_ID = l_pk1_value
2463: and SYSDATE BETWEEN NVL(icc.START_DATE_ACTIVE, SYSDATE) and NVL(icc.END_DATE_ACTIVE, SYSDATE);
2464: end if;
2465: exception