APPS.PA_BIS_SUMMARY dependencies on PA_BIS_TOTALS_BY_PRD

Line 643: DELETE FROM PA_BIS_TOTALS_BY_PRD;

639:
640: DELETE FROM PA_BIS_PRJ_BY_PRD_DRILLS;
641: DELETE FROM PA_BIS_PRJ_TO_DATE_DRILLS;
642: DELETE FROM PA_BIS_TO_DATE_DRILLS;
643: DELETE FROM PA_BIS_TOTALS_BY_PRD;
644: DELETE FROM PA_BIS_TOTALS_TO_DATE;
645:
646: COMMIT;
647:

Line 1297: INSERT INTO PA_BIS_TOTALS_BY_PRD

1293: COMMIT;
1294:
1295: FOR prd_drills_rec4 IN c_prd_drills4 LOOP
1296:
1297: INSERT INTO PA_BIS_TOTALS_BY_PRD
1298: (
1299: amount_type_code
1300: , period_name
1301: , accumulation_period_type

Line 1320: INSERT INTO PA_BIS_TOTALS_BY_PRD

1316: , x_org_id
1317: ,prd_drills_rec4.ACT_REVENUE
1318: ,prd_drills_rec4.BUD_REVENUE);
1319:
1320: INSERT INTO PA_BIS_TOTALS_BY_PRD
1321: (
1322: amount_type_code
1323: , period_name
1324: , accumulation_period_type