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.

APPS.IEX_DUNNING_PVT dependencies on IEX_DUNNING_PLANS_VL

Line 4004: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005

4000: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
4001: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
4002: SELECT a.score_value
4003: FROM IEX_SCORE_HISTORIES a
4004: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
4005: WHERE a.score_object_ID = in_ID
4006: AND a.score_object_code = IN_CODE
4007: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
4008: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005

Line 4026: iex_dunning_plans_vl d

4022: upper(x.callback_flag),
4023: x.callback_days
4024: FROM IEX_AG_DN_XREF x,
4025: ar_aging_buckets ar,
4026: iex_dunning_plans_vl d
4027: WHERE x.aging_bucket_line_ID = l_line_ID
4028: and x.dunning_plan_id = p_dunning_plan_id
4029: AND l_score between x.score_range_low and x.score_range_high
4030: AND x.aging_bucket_id = ar.aging_bucket_id

Line 5271: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005

5267: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
5268: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
5269: SELECT a.score_value
5270: FROM IEX_SCORE_HISTORIES a
5271: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
5272: WHERE a.score_object_ID = in_ID
5273: AND a.score_object_code = IN_CODE
5274: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
5275: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005

Line 5292: iex_dunning_plans_vl d

5288: upper(x.callback_flag),
5289: x.callback_days
5290: FROM IEX_AG_DN_XREF x,
5291: ar_aging_buckets ar,
5292: iex_dunning_plans_vl d
5293: WHERE x.aging_bucket_line_ID = l_line_ID
5294: and x.dunning_plan_id = p_dunning_plan_id
5295: AND l_score between x.score_range_low and x.score_range_high
5296: AND x.aging_bucket_id = ar.aging_bucket_id

Line 6926: from iex_dunning_plans_vl ipd, IEX_SCORES isc

6922: order by creation_date desc;
6923:
6924: cursor c_del_object_type(p_dunn_plan_id number) is
6925: select isc.jtf_object_code
6926: from iex_dunning_plans_vl ipd, IEX_SCORES isc
6927: where ipd.dunning_plan_id = p_dunn_plan_id
6928: and ipd.score_id=isc.score_id;
6929:
6930: l_del_object_type varchar2(50);

Line 6947: iex_dunning_plans_vl d

6943: x.callback_days,
6944: ar.bucket_name
6945: FROM IEX_AG_DN_XREF x,
6946: ar_aging_buckets ar,
6947: iex_dunning_plans_vl d
6948: WHERE x.aging_bucket_line_ID = l_line_ID
6949: and x.dunning_plan_id = p_dunning_plan_id
6950: AND l_score between x.score_range_low and x.score_range_high
6951: AND x.aging_bucket_id = ar.aging_bucket_id

Line 7972: from iex_dunning_plans_vl ipd, IEX_SCORES isc

7968: order by creation_date desc;
7969:
7970: cursor c_del_object_type(p_dunn_plan_id number) is
7971: select isc.jtf_object_code
7972: from iex_dunning_plans_vl ipd, IEX_SCORES isc
7973: where ipd.dunning_plan_id = p_dunn_plan_id
7974: and ipd.score_id=isc.score_id;
7975:
7976: l_del_object_type varchar2(50);

Line 7993: iex_dunning_plans_vl d

7989: x.callback_days,
7990: ar.bucket_name
7991: FROM IEX_AG_DN_XREF x,
7992: ar_aging_buckets ar,
7993: iex_dunning_plans_vl d
7994: WHERE x.aging_bucket_line_ID = l_line_ID
7995: and x.dunning_plan_id = p_dunning_plan_id
7996: AND l_score between x.score_range_low and x.score_range_high
7997: AND x.aging_bucket_id = ar.aging_bucket_id

Line 9147: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005

9143: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
9144: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
9145: SELECT a.score_value
9146: FROM IEX_SCORE_HISTORIES a
9147: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
9148: WHERE a.score_object_ID = in_ID
9149: AND a.score_object_code = IN_CODE
9150: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
9151: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005

Line 9168: iex_dunning_plans_vl d

9164: upper(x.callback_flag),
9165: x.callback_days
9166: FROM IEX_AG_DN_XREF x,
9167: ar_aging_buckets ar,
9168: iex_dunning_plans_vl d
9169: WHERE x.aging_bucket_line_ID = l_line_ID
9170: and x.dunning_plan_id = p_dunning_plan_id
9171: AND l_score between x.score_range_low and x.score_range_high
9172: AND x.aging_bucket_id = ar.aging_bucket_id

Line 10228: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005

10224: -- begin bug 4914799 ctlee 12/30/2005 add p_dunning_plan_id
10225: CURSOR C_GET_SCORE (IN_ID NUMBER, IN_CODE VARCHAR2, p_dunning_plan_id number) IS
10226: SELECT a.score_value
10227: FROM IEX_SCORE_HISTORIES a
10228: , IEX_DUNNING_PLANS_VL c -- bug 4914799 ctlee 12/30/2005
10229: WHERE a.score_object_ID = in_ID
10230: AND a.score_object_code = IN_CODE
10231: and c.score_id = a.score_id -- bug 4914799 ctlee 12/30/2005
10232: and c.dunning_plan_id = p_dunning_plan_id -- bug 4914799 ctlee 12/30/2005

Line 10248: iex_dunning_plans_vl d

10244: upper(x.callback_flag),
10245: x.callback_days
10246: FROM IEX_AG_DN_XREF x,
10247: ar_aging_buckets ar,
10248: iex_dunning_plans_vl d
10249: WHERE x.aging_bucket_line_ID = l_line_ID
10250: and x.dunning_plan_id = p_dunning_plan_id
10251: AND l_score between x.score_range_low and x.score_range_high
10252: AND x.aging_bucket_id = ar.aging_bucket_id

Line 11200: iex_dunning_plans_vl d

11196: x.callback_days,
11197: ar.bucket_name
11198: FROM IEX_AG_DN_XREF x,
11199: ar_aging_buckets ar,
11200: iex_dunning_plans_vl d
11201: WHERE x.aging_bucket_line_ID = l_line_ID
11202: and x.dunning_plan_id = p_dunning_plan_id
11203: AND l_score between x.score_range_low and x.score_range_high
11204: AND x.aging_bucket_id = ar.aging_bucket_id

Line 11992: iex_dunning_plans_vl d

11988: x.callback_days,
11989: ar.bucket_name
11990: FROM IEX_AG_DN_XREF x,
11991: ar_aging_buckets ar,
11992: iex_dunning_plans_vl d
11993: WHERE x.aging_bucket_line_ID = l_line_ID
11994: and x.dunning_plan_id = p_dunning_plan_id
11995: AND l_score between x.score_range_low and x.score_range_high
11996: AND x.aging_bucket_id = ar.aging_bucket_id

Line 12824: iex_dunning_plans_vl d

12820: CURSOR C_GET_BUCKET_LINE (IN_DAYS NUMBER, p_dunning_plan_id number) IS
12821: SELECT l.aging_bucket_line_id
12822: FROM ar_aging_bucket_lines l,
12823: ar_aging_buckets b,
12824: iex_dunning_plans_vl d
12825: WHERE d.dunning_plan_id = p_dunning_plan_id
12826: and d.aging_bucket_id = b.aging_bucket_id
12827: and b.aging_bucket_id = l.aging_bucket_id
12828: --AND round(IN_DAYS) between l.days_start and l.days_to

Line 18001: l_dunning_plan iex_dunning_plans_vl.name%type;

17997: ' AND d.object_type <> ''IEX_INVOICES'' ) ' ||
17998: -- 'order by lower(p.party_name)' ;
17999: 'order by NLSSORT(lower(p.party_name),''NLS_SORT=BINARY'')'; -- added by sunagesh for bug 13877178
18000: l_report_date varchar2(30);
18001: l_dunning_plan iex_dunning_plans_vl.name%type;
18002: l_req_id number;
18003: l_encoding VARCHAR2(100); --Added for bug 10141904 gnramasa 24th Sep 10
18004:
18005: begin

Line 18015: from iex_dunning_plans_vl

18011: from dual;
18012:
18013: select name
18014: into l_dunning_plan
18015: from iex_dunning_plans_vl
18016: where dunning_plan_id= p_dunning_plan_id;
18017:
18018: open c_calculate_no_rec (l_req_id);
18019: fetch c_calculate_no_rec into l_no_of_rec_prc, l_no_of_succ_rec, l_no_of_fail_rec;