APPS.XTR_XTRTMODR_XMLP_PKG dependencies on DUAL

Line 6: 'SELECT DECODE(SIGN(:INT_OD_RUNNING - :INT_OVERDUE2 - :INT_OVERDUE),-1,DECODE(SIGN(:INT_OD_RUNNING - :INT_OVERDUE),1,0,round(:INT_OVERDUE2,2)),0) INTO :INT_COMPONENT FROM DUAL';

2: /* $Header: XTRTMODRB.pls 120.1 2007/12/31 12:26:20 vjaganat noship $ */
3: FUNCTION INT_COMPONENT1FORMULA RETURN VARCHAR2 IS
4: BEGIN
5: EXECUTE IMMEDIATE
6: 'SELECT DECODE(SIGN(:INT_OD_RUNNING - :INT_OVERDUE2 - :INT_OVERDUE),-1,DECODE(SIGN(:INT_OD_RUNNING - :INT_OVERDUE),1,0,round(:INT_OVERDUE2,2)),0) INTO :INT_COMPONENT FROM DUAL';
7: COMMIT;
8: RETURN ('');
9: END INT_COMPONENT1FORMULA;
10:

Line 14: 'SELECT DECODE(SIGN(:BAL_RUNNING - :BAL_OVERDUE2 - :BAL_OVERDUE),-1,DECODE(SIGN(:BAL_RUNNING - :BAL_OVERDUE),1,round(:BAL_OVERDUE - :BAL_RUNNING + :BAL_OVERDUE2,2),0,0,round(:BAL_OVERDUE2,2)),0) INTO :BAL_COMPONENT FROM DUAL';

10:
11: FUNCTION BAL_COMPONENT1FORMULA RETURN VARCHAR2 IS
12: BEGIN
13: EXECUTE IMMEDIATE
14: 'SELECT DECODE(SIGN(:BAL_RUNNING - :BAL_OVERDUE2 - :BAL_OVERDUE),-1,DECODE(SIGN(:BAL_RUNNING - :BAL_OVERDUE),1,round(:BAL_OVERDUE - :BAL_RUNNING + :BAL_OVERDUE2,2),0,0,round(:BAL_OVERDUE2,2)),0) INTO :BAL_COMPONENT FROM DUAL';
15: COMMIT;
16: RETURN ('');
17: END BAL_COMPONENT1FORMULA;
18:

Line 22: 'SELECT NVL(round(:INT_COMPONENT,2),0) + nvl(round(:BAL_COMPONENT,2),0) INTO :TOT_OVERDUE from DUAL';

18:
19: FUNCTION TOT_OVERDUE1FORMULA RETURN VARCHAR2 IS
20: BEGIN
21: EXECUTE IMMEDIATE
22: 'SELECT NVL(round(:INT_COMPONENT,2),0) + nvl(round(:BAL_COMPONENT,2),0) INTO :TOT_OVERDUE from DUAL';
23: COMMIT;
24: RETURN ('');
25: END TOT_OVERDUE1FORMULA;
26:

Line 30: 'SELECT DECODE(:DAY30P + :DAY60P + :DAY90P,0,:TOT_OVERDUE,0) INTO :CURR FROM DUAL';

26:
27: FUNCTION CURR1FORMULA RETURN VARCHAR2 IS
28: BEGIN
29: EXECUTE IMMEDIATE
30: 'SELECT DECODE(:DAY30P + :DAY60P + :DAY90P,0,:TOT_OVERDUE,0) INTO :CURR FROM DUAL';
31: COMMIT;
32: RETURN ('');
33: END CURR1FORMULA;
34:

Line 38: 'SELECT DECODE(:DAY60P + :DAY90P,0,DECODE(SIGN(:NUMDAY - 1),1,:TOT_OVERDUE,0),0) INTO :DAY30P FROM DUAL';

34:
35: FUNCTION DAY30P1FORMULA RETURN VARCHAR2 IS
36: BEGIN
37: EXECUTE IMMEDIATE
38: 'SELECT DECODE(:DAY60P + :DAY90P,0,DECODE(SIGN(:NUMDAY - 1),1,:TOT_OVERDUE,0),0) INTO :DAY30P FROM DUAL';
39: COMMIT;
40: RETURN ('');
41: END DAY30P1FORMULA;
42:

Line 46: 'SELECT DECODE(:DAY90P,0,DECODE(SIGN(:NUMDAY - 2),1,:TOT_OVERDUE,0),0) INTO :DAY60P FROM DUAL';

42:
43: FUNCTION DAY60P1FORMULA RETURN VARCHAR2 IS
44: BEGIN
45: EXECUTE IMMEDIATE
46: 'SELECT DECODE(:DAY90P,0,DECODE(SIGN(:NUMDAY - 2),1,:TOT_OVERDUE,0),0) INTO :DAY60P FROM DUAL';
47: COMMIT;
48: RETURN ('');
49: END DAY60P1FORMULA;
50:

Line 54: 'SELECT DECODE(SIGN(:NUMDAY - 3),1,:TOT_OVERDUE,0) INTO :DAY90P FROM DUAL';

50:
51: FUNCTION DAY90P1FORMULA RETURN VARCHAR2 IS
52: BEGIN
53: EXECUTE IMMEDIATE
54: 'SELECT DECODE(SIGN(:NUMDAY - 3),1,:TOT_OVERDUE,0) INTO :DAY90P FROM DUAL';
55: COMMIT;
56: RETURN ('');
57: END DAY90P1FORMULA;
58:

Line 75: DUAL;

71: ,10)
72: INTO
73: CP_PARA
74: FROM
75: DUAL;
76: RETURN (CP_PARA);
77: END CF_SET_PARAFORMULA;
78:
79: FUNCTION BEFOREREPORT RETURN BOOLEAN IS