APPS.AP_WEB_MANAGEMENT_REPORTS_PKG dependencies on AP_WEB_MANAGEMENT_REPORTS_GT

Line 791: DELETE FROM AP_WEB_MANAGEMENT_REPORTS_GT;

787:
788: END LOOP;
789:
790: -- Clear previous query results
791: DELETE FROM AP_WEB_MANAGEMENT_REPORTS_GT;
792:
793: FOR i in 1..L_TabIndex
794: LOOP
795: -- Insert search results into global temporary table

Line 796: INSERT INTO AP_WEB_MANAGEMENT_REPORTS_GT (

792:
793: FOR i in 1..L_TabIndex
794: LOOP
795: -- Insert search results into global temporary table
796: INSERT INTO AP_WEB_MANAGEMENT_REPORTS_GT (
797: EMPLOYEE_ID,
798: SUPERVISOR_ID,
799: TOTAL_EXPENSES,
800: VIOLATION_LINE_AMOUNT,

Line 1368: DELETE FROM AP_WEB_MANAGEMENT_REPORTS_GT;

1364:
1365: END LOOP;
1366:
1367: -- Clear previous query results
1368: DELETE FROM AP_WEB_MANAGEMENT_REPORTS_GT;
1369:
1370: FOR i in 1..L_TabIndex
1371: LOOP
1372: -- Insert search results into global temporary table

Line 1373: INSERT INTO AP_WEB_MANAGEMENT_REPORTS_GT (

1369:
1370: FOR i in 1..L_TabIndex
1371: LOOP
1372: -- Insert search results into global temporary table
1373: INSERT INTO AP_WEB_MANAGEMENT_REPORTS_GT (
1374: EMPLOYEE_ID,
1375: TOTAL_EXPENSES,
1376: VIOLATION_LINE_AMOUNT,
1377: VIOLATION_AMOUNT,

Line 1868: DELETE FROM AP_WEB_MANAGEMENT_REPORTS_GT;

1864:
1865: END LOOP;
1866:
1867: -- Clear previous query results
1868: DELETE FROM AP_WEB_MANAGEMENT_REPORTS_GT;
1869:
1870: FOR i in 1..L_TabIndex
1871: LOOP
1872: -- Insert search results into global temporary table

Line 1873: INSERT INTO AP_WEB_MANAGEMENT_REPORTS_GT (

1869:
1870: FOR i in 1..L_TabIndex
1871: LOOP
1872: -- Insert search results into global temporary table
1873: INSERT INTO AP_WEB_MANAGEMENT_REPORTS_GT (
1874: EMPLOYEE_ID,
1875: VIOLATION_LINE_AMOUNT,
1876: VIOLATION_AMOUNT,
1877: ALLOWABLE_AMOUNT,