DBA Data[Home] [Help]

APPS.QA_WEB_TXN_API dependencies on DUAL

Line 749: from dual where exists (

745: -- skolluku
746: --
747: if (p_txn_number = 31) then --maintenance work order completion
748: select 'Y' into l_results_entered
749: from dual where exists (
750: select collection_id from QA_RESULTS
751: where organization_id = p_organization_id
752: and work_order_id =l_wip_entity_id
753: and (maintenance_op_seq is null or transaction_number = 31)

Line 759: select 'Y' into l_results_entered from dual

755: and (status is null or status=2 or --results be either enabled or belong to p_collection_id
756: (p_collection_id is not null and collection_id = p_collection_id))
757: );
758: elsif (p_txn_number = 33) then --maintenance op completion
759: select 'Y' into l_results_entered from dual
760: where exists (
761: select collection_id from QA_RESULTS
762: where organization_id = p_organization_id
763: and work_order_id =l_wip_entity_id