APPS.XTR_XTRTMAVG_XMLP_PKG dependencies on DUAL

Line 6: 'SELECT ((:SUM_WAVG_AMT / :SUM_BALANCE) * 100) INTO :WAVG_RATE FROM DUAL';

2: /* $Header: XTRTMAVGB.pls 120.1 2007/12/28 13:01:23 npannamp noship $ */
3: FUNCTION WAVG_RATE1FORMULA RETURN VARCHAR2 IS
4: BEGIN
5: /* EXECUTE IMMEDIATE
6: 'SELECT ((:SUM_WAVG_AMT / :SUM_BALANCE) * 100) INTO :WAVG_RATE FROM DUAL';
7: COMMIT;*/
8: RETURN ('');
9: END WAVG_RATE1FORMULA;
10:

Line 19: 'SELECT (:SUM_BALANCE / :NUM_TRANS) INTO :AVG_AMOUNT FROM DUAL';

15:
16: FUNCTION AVG_AMOUNT1FORMULA RETURN VARCHAR2 IS
17: BEGIN
18: /* EXECUTE IMMEDIATE
19: 'SELECT (:SUM_BALANCE / :NUM_TRANS) INTO :AVG_AMOUNT FROM DUAL';
20: COMMIT;*/
21: RETURN ('');
22: END AVG_AMOUNT1FORMULA;
23:

Line 38: DUAL;

34: ,10)
35: INTO
36: CP_PARA
37: FROM
38: DUAL;
39: RETURN (CP_PARA);
40: END CF_SET_PARAFORMULA;
41:
42: FUNCTION BEFOREREPORT RETURN BOOLEAN IS