DBA Data[Home] [Help]

APPS.EAM_OP_VALIDATE_PVT dependencies on WIP_COST_TXN_INTERFACE

Line 1064: -- For checking resource transaction use wip_cost_txn_interface.

1060: EXCEPTION
1061: WHEN no_data_found THEN
1062: l_return := 'Y';
1063: END ;
1064: -- For checking resource transaction use wip_cost_txn_interface.
1065:
1066: select count(*) into l_tx_count from dual
1067: where EXISTS (SELECT transaction_id FROM wip_cost_txn_interface
1068: WHERE wip_entity_id = p_wip_entity_id

Line 1067: where EXISTS (SELECT transaction_id FROM wip_cost_txn_interface

1063: END ;
1064: -- For checking resource transaction use wip_cost_txn_interface.
1065:
1066: select count(*) into l_tx_count from dual
1067: where EXISTS (SELECT transaction_id FROM wip_cost_txn_interface
1068: WHERE wip_entity_id = p_wip_entity_id
1069: AND operation_seq_num = p_op_seq_num);
1070:
1071: IF l_tx_count > 0 THEN