DBA Data[Home] [Help]

APPS.CST_EAMJOB_ACTESTIMATE dependencies on CST_EAM_ACTIVITY_ESTIMATES

Line 1171: SELECT cst_eam_activity_estimates_s.nextval

1167: END IF;
1168:
1169: IF l_ActivityEstimateTable.EXISTS(1) THEN
1170:
1171: SELECT cst_eam_activity_estimates_s.nextval
1172: INTO l_activity_estimate_record_id
1173: FROM DUAL;
1174:
1175:

Line 1178: INSERT INTO cst_eam_activity_estimates (

1174:
1175:
1176: FOR j IN l_ActivityEstimateTable.FIRST .. l_ActivityEstimateTable.LAST LOOP
1177:
1178: INSERT INTO cst_eam_activity_estimates (
1179: activity_estimate_record_id,
1180: record_type,
1181: organization_id,
1182: activity_item_id,

Line 1199: INSERT INTO cst_eam_activity_estimates (

1195: );
1196:
1197: END LOOP;
1198:
1199: INSERT INTO cst_eam_activity_estimates (
1200: activity_estimate_record_id,
1201: record_type,
1202: organization_id,
1203: activity_item_id,

Line 1215: FROM cst_eam_activity_estimates caet

1211: activity_item_id activity_item_id,
1212: eam_cost_element eam_cost_element,
1213: maint_cost_category maint_cost_category,
1214: SUM(cost_value) cost_value
1215: FROM cst_eam_activity_estimates caet
1216: GROUP BY l_activity_estimate_record_id,
1217: record_type,
1218: organization_id,
1219: activity_item_id,