APPS.PA_BIS_SUMMARY dependencies on PA_BIS_PRJ_BY_PRD_DRILLS

Line 640: DELETE FROM PA_BIS_PRJ_BY_PRD_DRILLS;

636: and pa_per.current_pa_period_flag = 'Y';
637:
638:
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;

Line 650: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS (

646: COMMIT;
647:
648: FOR prd_drills_rec1 IN c_prd_drills1 LOOP
649:
650: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS (
651: drilldown_type
652: , amount_type_code
653: , drilldown_key1
654: , project_id

Line 677: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS (

673: ,x_org_id
674: ,prd_drills_rec1.ACT_REVENUE
675: ,prd_drills_rec1.BUD_REVENUE);
676:
677: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS (
678: drilldown_type
679: , amount_type_code
680: , drilldown_key1
681: , project_id

Line 715: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS

711:
712:
713:
714: FOR prd_drills_rec2 IN c_prd_drills2 LOOP
715: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS
716: (
717: drilldown_type
718: , amount_type_code
719: , drilldown_key1

Line 745: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS

741: ,x_org_id
742: ,prd_drills_rec2.ACT_COST
743: ,prd_drills_rec2.BUD_COST);
744:
745: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS
746: (
747: drilldown_type
748: , amount_type_code
749: , drilldown_key1

Line 782: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS

778: COMMIT;
779:
780:
781: FOR prd_drills_rec3 IN c_prd_drills3 LOOP
782: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS
783: (
784: drilldown_type
785: , amount_type_code
786: , drilldown_key1

Line 812: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS

808: ,x_org_id
809: ,prd_drills_rec3.ACT_COST
810: ,prd_drills_rec3.BUD_COST);
811:
812: INSERT INTO PA_BIS_PRJ_BY_PRD_DRILLS
813: (
814: drilldown_type
815: , amount_type_code
816: , drilldown_key1