215:
216: -- Select estimate number, take -ve to denote estimation status is running
217: SELECT -1 * cst_wip_cost_estimates_s.NEXTVAL
218: INTO l_estimation_group_id
219: FROM DUAL;
220:
221: l_stmt_num := 20;
222:
223: /* Insert all discrete jobs not present in estimation table i.e. All
4313:
4314: MERGE INTO CST_PAC_EAM_BALANCE_BY_ACCTS cebba
4315: USING
4316: (
4317: SELECT NULL FROM DUAL
4318: ) temp
4319: ON
4320: (
4321: cebba.legal_entity_id = p_legal_entity_id AND