eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IEX_DUNNING_PVT dependencies on XDO_TEMPLATES_VL

Line 4037: from xdo_templates_vl xdo

4033: AND x.dunning_level = IN_LEVEL ;
4034:
4035: CURSOR C_TEMPLATE_STATUS (l_template_id number) is
4036: select 'Active'
4037: from xdo_templates_vl xdo
4038: where xdo.template_id = l_template_id
4039: and trunc(sysdate) >= TRUNC (NVL(xdo.start_date, sysdate))
4040: and trunc(sysdate) < TRUNC(NVL(xdo.end_date, sysdate + 1));
4041:

Line 4044: from xdo_templates_vl xdo

4040: and trunc(sysdate) < TRUNC(NVL(xdo.end_date, sysdate + 1));
4041:
4042: CURSOR C_TEMPLATE_NAME (l_template_id number) is
4043: select template_name
4044: from xdo_templates_vl xdo
4045: where xdo.template_id = l_template_id;
4046:
4047: l_template_name varchar2(500);
4048:

Line 5303: from xdo_templates_vl xdo

5299: AND x.dunning_level = IN_LEVEL ;
5300:
5301: CURSOR C_TEMPLATE_STATUS (l_template_id number) is
5302: select 'Active'
5303: from xdo_templates_vl xdo
5304: where xdo.template_id = l_template_id
5305: and trunc(sysdate) >= TRUNC (NVL(xdo.start_date, sysdate))
5306: and trunc(sysdate) < TRUNC(NVL(xdo.end_date, sysdate + 1));
5307:

Line 5312: from xdo_templates_vl xdo

5308: l_template_status varchar2(10);
5309:
5310: CURSOR C_TEMPLATE_NAME (l_template_id number) is
5311: select template_name
5312: from xdo_templates_vl xdo
5313: where xdo.template_id = l_template_id;
5314:
5315: l_template_name varchar2(500);
5316:

Line 6958: from xdo_templates_vl xdo

6954: AND x.dunning_level = 'DELINQUENCY' ;
6955:
6956: CURSOR C_TEMPLATE_STATUS (l_template_id number) is
6957: select 'Active'
6958: from xdo_templates_vl xdo
6959: where xdo.template_id = l_template_id
6960: and trunc(sysdate) >= TRUNC (NVL(xdo.start_date, sysdate))
6961: and trunc(sysdate) < TRUNC(NVL(xdo.end_date, sysdate + 1));
6962:

Line 6967: from xdo_templates_vl xdo

6963: l_template_status varchar2(10);
6964:
6965: CURSOR C_TEMPLATE_NAME (l_template_id number) is
6966: select template_name
6967: from xdo_templates_vl xdo
6968: where xdo.template_id = l_template_id;
6969:
6970: l_template_name varchar2(500);
6971: --

Line 8004: from xdo_templates_vl xdo

8000: AND x.dunning_level = 'DELINQUENCY' ;
8001:
8002: CURSOR C_TEMPLATE_STATUS (l_template_id number) is
8003: select 'Active'
8004: from xdo_templates_vl xdo
8005: where xdo.template_id = l_template_id
8006: and trunc(sysdate) >= TRUNC (NVL(xdo.start_date, sysdate))
8007: and trunc(sysdate) < TRUNC(NVL(xdo.end_date, sysdate + 1));
8008:

Line 8013: from xdo_templates_vl xdo

8009: l_template_status varchar2(10);
8010:
8011: CURSOR C_TEMPLATE_NAME (l_template_id number) is
8012: select template_name
8013: from xdo_templates_vl xdo
8014: where xdo.template_id = l_template_id;
8015:
8016: l_template_name varchar2(500);
8017: --

Line 9179: from xdo_templates_vl xdo

9175: AND x.dunning_level = IN_LEVEL ;
9176:
9177: CURSOR C_TEMPLATE_STATUS (l_template_id number) is
9178: select 'Active'
9179: from xdo_templates_vl xdo
9180: where xdo.template_id = l_template_id
9181: and trunc(sysdate) >= TRUNC (NVL(xdo.start_date, sysdate))
9182: and trunc(sysdate) < TRUNC(NVL(xdo.end_date, sysdate + 1));
9183:

Line 9188: from xdo_templates_vl xdo

9184: l_template_status varchar2(10);
9185:
9186: CURSOR C_TEMPLATE_NAME (l_template_id number) is
9187: select template_name
9188: from xdo_templates_vl xdo
9189: where xdo.template_id = l_template_id;
9190:
9191: cursor c_dunning_plan_dtl (p_dunn_plan_id number) is
9192: select nvl(dunn.grace_days ,'N'),

Line 10259: from xdo_templates_vl xdo

10255: AND x.dunning_level = IN_LEVEL ;
10256: */
10257: CURSOR C_TEMPLATE_STATUS (l_template_id number) is
10258: select 'Active'
10259: from xdo_templates_vl xdo
10260: where xdo.template_id = l_template_id
10261: and trunc(sysdate) >= TRUNC (NVL(xdo.start_date, sysdate))
10262: and trunc(sysdate) < TRUNC(NVL(xdo.end_date, sysdate + 1));
10263:

Line 10268: from xdo_templates_vl xdo

10264: l_template_status varchar2(10);
10265:
10266: CURSOR C_TEMPLATE_NAME (l_template_id number) is
10267: select template_name
10268: from xdo_templates_vl xdo
10269: where xdo.template_id = l_template_id;
10270:
10271: l_template_name varchar2(500);
10272: --

Line 11211: from xdo_templates_vl xdo

11207: AND x.dunning_level = 'DELINQUENCY' ;
11208:
11209: CURSOR C_TEMPLATE_STATUS (l_template_id number) is
11210: select 'Active'
11211: from xdo_templates_vl xdo
11212: where xdo.template_id = l_template_id
11213: and trunc(sysdate) >= TRUNC (NVL(xdo.start_date, sysdate))
11214: and trunc(sysdate) < TRUNC(NVL(xdo.end_date, sysdate + 1));
11215:

Line 11220: from xdo_templates_vl xdo

11216: l_template_status varchar2(10);
11217:
11218: CURSOR C_TEMPLATE_NAME (l_template_id number) is
11219: select template_name
11220: from xdo_templates_vl xdo
11221: where xdo.template_id = l_template_id;
11222:
11223: l_template_name varchar2(500);
11224: --

Line 12003: from xdo_templates_vl xdo

11999: AND x.dunning_level = 'DELINQUENCY' ;
12000: */
12001: CURSOR C_TEMPLATE_STATUS (l_template_id number) is
12002: select 'Active'
12003: from xdo_templates_vl xdo
12004: where xdo.template_id = l_template_id
12005: and trunc(sysdate) >= TRUNC (NVL(xdo.start_date, sysdate))
12006: and trunc(sysdate) < TRUNC(NVL(xdo.end_date, sysdate + 1));
12007:

Line 12012: from xdo_templates_vl xdo

12008: l_template_status varchar2(10);
12009:
12010: CURSOR C_TEMPLATE_NAME (l_template_id number) is
12011: select template_name
12012: from xdo_templates_vl xdo
12013: where xdo.template_id = l_template_id;
12014:
12015: l_template_name varchar2(500);
12016:

Line 14161: from xdo_templates_vl xdo

14157: l_query_temp_id NUMBER;
14158: l_addt_query_temp_id number;
14159: CURSOR C_TEMPLATE_STATUS (l_template_id number) is
14160: select 'Active'
14161: from xdo_templates_vl xdo
14162: where xdo.template_id = l_template_id
14163: and trunc(sysdate) >= TRUNC (NVL(xdo.start_date, sysdate))
14164: and trunc(sysdate) < TRUNC(NVL(xdo.end_date, sysdate + 1));
14165:

Line 14170: from xdo_templates_vl xdo

14166: l_template_status varchar2(10);
14167:
14168: CURSOR C_TEMPLATE_NAME (l_template_id number) is
14169: select template_name
14170: from xdo_templates_vl xdo
14171: where xdo.template_id = l_template_id;
14172:
14173: l_template_name varchar2(500);
14174: