APPS.PA_PAXMGURA_XMLP_PKG dependencies on DUAL

Line 144: SYS.DUAL;

140: ( NVL(DATE_FROM
141: ,SYSDATE) - ( BUCKET_SIZE3 + BUCKET_SIZE2 + BUCKET_SIZE1 ) )
142: INTO DATE1,DATE2,DATE3
143: FROM
144: SYS.DUAL;
145: UPDATE
146: PA_UNBILLED_REC_REPORTING TU
147: SET
148: (EI_BUCKET1,EI_BUCKET2,EI_BUCKET3,EI_BUCKET4) = (SELECT

Line 343: SYS.DUAL;

339: LPAD(TO_CHAR(BUCKET_SIZE1 + BUCKET_SIZE2 + BUCKET_SIZE3 + 1) || '+ days'
340: ,14)
341: INTO COLHEAD1,COLHEAD2,COLHEAD3,COLHEAD4
342: FROM
343: SYS.DUAL;
344: C_COLHEAD1 := COLHEAD1;
345: C_COLHEAD2 := COLHEAD2;
346: C_COLHEAD3 := COLHEAD3;
347: C_COLHEAD4 := COLHEAD4;

Line 361: SYS.DUAL;

357: ( NVL(DATE_FROM
358: ,SYSDATE) - ( BUCKET_SIZE3 + BUCKET_SIZE2 + BUCKET_SIZE1 ) )
359: INTO DATE1,DATE2,DATE3
360: FROM
361: SYS.DUAL;
362: END SELECT_DATES;
363:
364: PROCEDURE INSERT_EIS IS
365: CURSOR C1 IS

Line 824: DUAL

820: SELECT
821: count(*)
822: INTO L_COUNT
823: FROM
824: DUAL
825: WHERE EXISTS (
826: SELECT
827: 1
828: FROM

Line 1216: SYS.DUAL;

1212: ,0
1213: ,SUB_AMOUNT - BUCKET4) - BUCKET3) - BUCKET2)
1214: INTO TEMP_BUCKET1
1215: FROM
1216: SYS.DUAL;
1217: FINAL_BUCKET1 := TEMP_BUCKET1 + INVOICE_REDUCTION + RETENTION;
1218: RETURN FINAL_BUCKET1;
1219: END CALC_BUCKET1;
1220:

Line 1250: SYS.DUAL;

1246: ,0
1247: ,SUB_AMOUNT - BUCKET4) - BUCKET3))
1248: INTO FINAL_BUCKET2
1249: FROM
1250: SYS.DUAL;
1251: RETURN FINAL_BUCKET2;
1252: END CALC_BUCKET2;
1253:
1254: FUNCTION CALC_BUCKET3(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER) RETURN NUMBER IS

Line 1271: DUAL;

1267: ,0
1268: ,SUB_AMOUNT - BUCKET4))
1269: INTO FINAL_BUCKET3
1270: FROM
1271: DUAL;
1272: RETURN FINAL_BUCKET3;
1273: END CALC_BUCKET3;
1274:
1275: FUNCTION CALC_BUCKET4(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER) RETURN NUMBER IS

Line 1286: DUAL;

1282: ,0
1283: ,BUCKET4 - SUB_AMOUNT)
1284: INTO FINAL_BUCKET4
1285: FROM
1286: DUAL;
1287: RETURN FINAL_BUCKET4;
1288: END CALC_BUCKET4;
1289:
1290: FUNCTION CALC_TOTAL_BUCKETS(EVENT_INVOICED_AMOUNT IN NUMBER,COST_WORK_AMOUNT IN NUMBER,BUCKET1 IN NUMBER,BUCKET2 IN NUMBER,BUCKET3 IN NUMBER,BUCKET4 IN NUMBER,INVOICE_REDUCTION IN NUMBER,RETENTION IN NUMBER) RETURN NUMBER IS