DBA Data[Home] [Help]

APPS.QA_WEB_TXN_API dependencies on DUAL

Line 723: from dual where exists (

719: 'l_plans_table('||i||'): ' || l_plans_table(i));
720: end if;
721: if (p_txn_number = 31) then --maintenance work order completion
722: select 'Y' into l_results_entered
723: from dual where exists (
724: select collection_id from QA_RESULTS
725: where organization_id = p_organization_id
726: and work_order_id =l_wip_entity_id
727: and maintenance_op_seq is null

Line 733: select 'Y' into l_results_entered from dual

729: and (status is null or status=2 or --results be either enabled or belong to p_collection_id
730: (p_collection_id is not null and collection_id = p_collection_id))
731: );
732: elsif (p_txn_number = 33) then --maintenance op completion
733: select 'Y' into l_results_entered from dual
734: where exists (
735: select collection_id from QA_RESULTS
736: where organization_id = p_organization_id
737: and work_order_id =l_wip_entity_id