DBA Data[Home] [Help]

APPS.EAM_WORKORDER_UTIL_PKG dependencies on WIP_COST_TXN_INTERFACE

Line 1057: FROM WIP_COST_TXN_INTERFACE

1053: FROM WIP_MOVE_TXN_INTERFACE
1054: WHERE ORGANIZATION_ID = x_org_id
1055: AND WIP_ENTITY_ID = x_wip_id)
1056: OR EXISTS (SELECT '1'
1057: FROM WIP_COST_TXN_INTERFACE
1058: WHERE ORGANIZATION_ID = x_org_id
1059: AND WIP_ENTITY_ID = x_wip_id);
1060:
1061: if charges_exist_2 = '1' then

Line 1342: FROM WIP_COST_TXN_INTERFACE

1338: FROM WIP_MOVE_TXN_INTERFACE
1339: WHERE ORGANIZATION_ID = x_org_id
1340: AND WIP_ENTITY_ID = x_wip_id)
1341: OR EXISTS (SELECT '1'
1342: FROM WIP_COST_TXN_INTERFACE
1343: WHERE ORGANIZATION_ID = x_org_id
1344: AND WIP_ENTITY_ID = x_wip_id);
1345: exception
1346: WHEN NO_DATA_FOUND then /* fix for the perf bug #2551622 */

Line 1668: FROM WIP_COST_TXN_INTERFACE

1664: FROM WIP_MOVE_TXN_INTERFACE
1665: WHERE ORGANIZATION_ID = p_org_id
1666: AND WIP_ENTITY_ID = p_wip_id)
1667: OR EXISTS(SELECT '1'
1668: FROM WIP_COST_TXN_INTERFACE
1669: WHERE ORGANIZATION_ID = p_org_id
1670: AND WIP_ENTITY_ID = p_wip_id);
1671: /* IF charges_exist_3 = '1' then
1672: p_return_status:= 3;