APPS.EAM_SUB_RESOURCE_VALIDATE_PVT dependencies on DUAL

Line 687: from DUAL

683: if (p_eam_sub_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
684:
685: select count(*)
686: into l_count_wt
687: from DUAL
688: WHERE EXISTS (SELECT 1
689: FROM wip_transactions
690: where wip_entity_id = p_eam_sub_res_rec.wip_entity_id
691: and organization_id = p_eam_sub_res_rec.organization_id

Line 702: from DUAL

698: end if;
699:
700: select count(*)
701: into l_count_wcti
702: from DUAL
703: WHERE EXISTS (SELECT 1
704: FROM wip_cost_txn_interface
705: where wip_entity_id = p_eam_sub_res_rec.wip_entity_id
706: and organization_id = p_eam_sub_res_rec.organization_id

Line 767: from DUAL

763: if (p_eam_sub_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE) then
764:
765: select count(*)
766: into l_count_po
767: from DUAL
768: WHERE EXISTS (SELECT 1
769: FROM po_requisitions_interface
770: where wip_entity_id = p_eam_sub_res_rec.wip_entity_id
771: and destination_organization_id = p_eam_sub_res_rec.organization_id

Line 783: from DUAL

779:
780:
781: select count(*)
782: into l_count_req
783: from DUAL
784: WHERE EXISTS (SELECT 1
785: FROM po_requisition_lines
786: where wip_entity_id = p_eam_sub_res_rec.wip_entity_id
787: and destination_organization_id = p_eam_sub_res_rec.organization_id

Line 799: from DUAL

795:
796:
797: select count(*)
798: into l_count_dist
799: from DUAL
800: WHERE EXISTS (SELECT 1
801: FROM po_distributions
802: where wip_entity_id = p_eam_sub_res_rec.wip_entity_id
803: and destination_organization_id = p_eam_sub_res_rec.organization_id