[Home] [Help]
736: AND cicdi2.cost_type_id = cicdi1.cost_type_id
737: AND cicdi2.cost_element_id in (3,4)
738: AND cicdi2.error_flag is null
739: AND cicdi2.group_id = SEQ_NEXTVAL
740: AND EXISTS (select 1 from CST_RESOURCE_OVERHEADS cro
741: WHERE cro.cost_type_id = cicdi1.cost_type_id
742: AND cro.organization_id = cicdi1.organization_id
743: AND cro.overhead_id = cicdi1.resource_id
744: AND cro.resource_id = cicdi2.resource_id))
782: AND cicdi2.cost_type_id = cicdi1.cost_type_id
783: AND cicdi2.error_flag is null
784: AND cicdi2.group_id = SEQ_NEXTVAL
785: AND cicdi2.cost_element_id IN (3,4)
786: AND EXISTS ( select 1 from CST_RESOURCE_OVERHEADS cro
787: WHERE cro.organization_id = cicdi2.organization_id
788: AND cro.cost_type_id = cicdi2.cost_type_id
789: AND cro.overhead_id = cicdi1.resource_id
790: AND cro.resource_id = cicdi2.resource_id))