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_UTILITIES dependencies on IEX_DELINQUENCIES_ALL

Line 113: Delete from iex_delinquencies_all where transaction_id = p_transaction_id;

109: delete_flag varchar2(1) := 'N';
110:
111: begin
112:
113: Delete from iex_delinquencies_all where transaction_id = p_transaction_id;
114: delete_flag := 'Y';
115: commit;
116: return delete_flag;
117:

Line 1557: select customer_site_use_id from iex_delinquencies_all

1553: -- where party_id = p_party_id and status = 'A' and site_use_id is null and cust_account_id is null;
1554: -- end bug 4587842 ctlee 09/06/2005
1555:
1556: cursor c_get_billto (p_delinquency_id number) is
1557: select customer_site_use_id from iex_delinquencies_all
1558: where delinquency_id = p_delinquency_id;
1559: BEGIN
1560:
1561: l_party_id := p_party_id;

Line 1693: from ar_payment_schedules_all a, iex_delinquencies_all b

1689: l_cm_ar_total_amount number:=0;
1690:
1691: cursor c_acc_dist_inv_cur (p_cust_account_id number,p_org_id number) is
1692: select distinct a.invoice_currency_code
1693: from ar_payment_schedules_all a, iex_delinquencies_all b
1694: where a.payment_schedule_id = b.payment_schedule_id
1695: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1696: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR')
1697: and a.status = 'OP'

Line 1704: from ar_payment_schedules_all a, iex_delinquencies_all b

1700: order by 1;
1701:
1702: cursor c_billto_dist_inv_cur (p_site_use_id number,p_org_id number) is
1703: select distinct a.invoice_currency_code
1704: from ar_payment_schedules_all a, iex_delinquencies_all b
1705: where a.payment_schedule_id = b.payment_schedule_id
1706: and b.status in ('DELINQUENT', 'PREDELINQUENT')
1707: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR')
1708: and a.status = 'OP'

Line 2192: from ar_payment_schedules_all aps,iex_delinquencies_all dd

2188: p_corr_date date,
2189: p_grace_days number,
2190: p_include_dis_items varchar) is
2191: select nvl(sum(aps.acctd_amount_due_remaining),0)
2192: from ar_payment_schedules_all aps,iex_delinquencies_all dd
2193: where dd.payment_schedule_id = aps.payment_schedule_id
2194: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR')
2195: and aps.status='OP'
2196: and (trunc(aps.due_date) + p_grace_days) <= p_correspondence_date

Line 2255: from ar_payment_schedules_all aps,iex_delinquencies_all dd

2251:
2252: cursor c_billto_tot_acctd_amt_rem (p_site_use_id number,p_org_id number,
2253: p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2254: select nvl(sum(aps.acctd_amount_due_remaining),0)
2255: from ar_payment_schedules_all aps,iex_delinquencies_all dd
2256: where dd.payment_schedule_id = aps.payment_schedule_id
2257: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR')
2258: and aps.status='OP'
2259: and (trunc(aps.due_date) + p_grace_days) <= p_corr_date

Line 2409: from ar_payment_schedules_all a, iex_delinquencies_all b

2405: cursor c_acc_tot_amt_due_rem (p_cust_account_id number, p_invoice_currency_code varchar2, p_min_dun_invoice_amount number
2406: , p_org_id number,p_correspondence_date date, p_grace_days number, p_include_dis_items varchar2)
2407: is
2408: select nvl(sum(a.amount_due_remaining),0)
2409: from ar_payment_schedules_all a, iex_delinquencies_all b
2410: where a.payment_schedule_id = b.payment_schedule_id
2411: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2412: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2413: and a.status = 'OP'

Line 2506: from ar_payment_schedules_all a, iex_delinquencies_all b

2502: , p_min_dun_invoice_amount number,p_org_id number, p_correspondence_date date, p_grace_days number
2503: , p_include_dis_items varchar2)
2504: is
2505: select nvl(sum(a.amount_due_remaining),0)
2506: from ar_payment_schedules_all a, iex_delinquencies_all b
2507: where a.payment_schedule_id = b.payment_schedule_id
2508: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2509: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change)
2510: and a.status = 'OP'

Line 2569: from ar_payment_schedules_all a, iex_delinquencies_all b

2565: IS
2566: l_api_name CONSTANT VARCHAR2(30) := 'amount_account';
2567: cursor c_amount_account (p_cust_account_id number, p_org_id number, p_correspondence_date date, p_grace_days number, p_include_dis_items varchar2) is
2568: select nvl(a.amount_due_remaining,0), a.invoice_currency_code, class
2569: from ar_payment_schedules_all a, iex_delinquencies_all b
2570: where a.payment_schedule_id = b.payment_schedule_id
2571: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2572: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2573: and a.status = 'OP'

Line 2684: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

2680: is
2681: l_api_name CONSTANT VARCHAR2(30) := 'amount_billto';
2682: cursor c_amount_billto (p_site_use_id number, p_org_id number, p_correspondence_date date, p_grace_days number, p_include_dis_items varchar2) is
2683: select nvl(a.amount_due_remaining, 0), a.invoice_currency_code, class
2684: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
2685: where a.payment_schedule_id = b.payment_schedule_id
2686: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2687: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2688: and a.status = 'OP'

Line 2859: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

2855:
2856: -- only open status
2857: cursor c_amount_billto (p_site_use_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2858: select nvl(a.amount_due_remaining, 0), a.invoice_currency_code, class
2859: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
2860: where a.payment_schedule_id = b.payment_schedule_id
2861: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2862: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2863: and a.status = 'OP'

Line 2901: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

2897:
2898: -- only open status
2899: cursor c_amount_account (p_cust_account_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2900: select nvl(a.amount_due_remaining,0), a.invoice_currency_code, class
2901: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
2902: where a.payment_schedule_id = b.payment_schedule_id
2903: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2904: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2905: and a.status = 'OP'

Line 2917: from ar_payment_schedules_all a, iex_delinquencies_all b

2913: l_tot_amt_due_rem number;
2914:
2915: cursor c_billto_dist_inv_cur (p_site_use_id number,p_org_id number) is
2916: select distinct a.invoice_currency_code
2917: from ar_payment_schedules_all a, iex_delinquencies_all b
2918: where a.payment_schedule_id = b.payment_schedule_id
2919: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2920: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2921: and a.status = 'OP'

Line 2934: from ar_payment_schedules_all a, iex_delinquencies_all b

2930: and currency_code = p_currency_code;
2931:
2932: cursor c_billto_tot_amt_due_rem (p_site_use_id number, p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2933: select sum(nvl(a.amount_due_remaining,0))
2934: from ar_payment_schedules_all a, iex_delinquencies_all b
2935: where a.payment_schedule_id = b.payment_schedule_id
2936: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2937: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change)
2938: and a.status = 'OP'

Line 2948: from ar_payment_schedules_all a, iex_delinquencies_all b

2944: and b.org_id = p_org_id;
2945:
2946: cursor c_acc_dist_inv_cur (p_cust_account_id number,p_org_id number) is
2947: select distinct a.invoice_currency_code
2948: from ar_payment_schedules_all a, iex_delinquencies_all b
2949: where a.payment_schedule_id = b.payment_schedule_id
2950: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2951: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2952: and a.status = 'OP'

Line 2966: from ar_payment_schedules_all a, iex_delinquencies_all b

2962: and site_use_id is null;
2963:
2964: cursor c_acc_tot_amt_due_rem (p_cust_account_id number, p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2965: select sum(nvl(a.amount_due_remaining,0))
2966: from ar_payment_schedules_all a, iex_delinquencies_all b
2967: where a.payment_schedule_id = b.payment_schedule_id
2968: and b.status in ('DELINQUENT', 'PREDELINQUENT')
2969: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2970: and a.status = 'OP'

Line 2995: from ar_payment_schedules_all aps,iex_delinquencies_all dd

2991: and org_id = p_org_id;
2992:
2993: cursor c_acct_tot_acctd_amt_rem (p_cust_account_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
2994: select nvl(sum(aps.acctd_amount_due_remaining),0)
2995: from ar_payment_schedules_all aps,iex_delinquencies_all dd
2996: where dd.payment_schedule_id = aps.payment_schedule_id
2997: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
2998: and aps.status='OP'
2999: and (trunc(aps.due_date) + p_grace_days) <= p_corr_date

Line 3016: from ar_payment_schedules_all aps,iex_delinquencies_all dd

3012: and org_id = p_org_id;
3013:
3014: cursor c_billto_tot_acctd_amt_rem (p_site_use_id number,p_org_id number, p_corr_date date, p_grace_days number, p_include_dis_items varchar) is
3015: select nvl(sum(aps.acctd_amount_due_remaining),0)
3016: from ar_payment_schedules_all aps,iex_delinquencies_all dd
3017: where dd.payment_schedule_id = aps.payment_schedule_id
3018: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3019: and aps.status='OP'
3020: and (trunc(aps.due_date) + p_grace_days) <= p_corr_date

Line 3564: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

3560:
3561: -- only open status
3562: cursor c_amount_billto (p_site_use_id number,p_org_id number) is
3563: select nvl(a.amount_due_remaining, 0), a.invoice_currency_code, class
3564: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
3565: where a.payment_schedule_id = b.payment_schedule_id
3566: and b.status in ('DELINQUENT', 'PREDELINQUENT')
3567: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3568: and a.status = 'OP'

Line 3593: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007

3589:
3590: -- only open status
3591: cursor c_amount_account (p_cust_account_id number,p_org_id number) is
3592: select nvl(a.amount_due_remaining,0), a.invoice_currency_code, class
3593: from ar_payment_schedules_all a, iex_delinquencies_all b --Changed to ar_payment_schedules_all for bug#5652343 by gnramasa on 07-Mar-2007
3594: where a.payment_schedule_id = b.payment_schedule_id
3595: and b.status in ('DELINQUENT', 'PREDELINQUENT')
3596: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3597: and a.status = 'OP'

Line 3607: from ar_payment_schedules_all a, iex_delinquencies_all b

3603: l_tot_amt_due_rem number;
3604:
3605: cursor c_billto_dist_inv_cur (p_site_use_id number,p_org_id number) is
3606: select distinct a.invoice_currency_code
3607: from ar_payment_schedules_all a, iex_delinquencies_all b
3608: where a.payment_schedule_id = b.payment_schedule_id
3609: --and b.status in ('DELINQUENT', 'PREDELINQUENT')
3610: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3611: and a.status = 'OP'

Line 3624: from ar_payment_schedules_all a, iex_delinquencies_all b

3620: and currency_code = p_currency_code;
3621:
3622: cursor c_billto_tot_amt_due_rem (p_site_use_id number, p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3623: select sum(nvl(a.amount_due_remaining,0))
3624: from ar_payment_schedules_all a, iex_delinquencies_all b
3625: where a.payment_schedule_id = b.payment_schedule_id
3626: and b.status in ('DELINQUENT', 'PREDELINQUENT')
3627: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3628: and a.status = 'OP'

Line 3636: from ar_payment_schedules_all a, iex_delinquencies_all b

3632: and b.org_id = p_org_id;
3633:
3634: cursor c_acc_dist_inv_cur (p_cust_account_id number,p_org_id number) is
3635: select distinct a.invoice_currency_code
3636: from ar_payment_schedules_all a, iex_delinquencies_all b
3637: where a.payment_schedule_id = b.payment_schedule_id
3638: --and b.status in ('DELINQUENT', 'PREDELINQUENT')
3639: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3640: and a.status = 'OP'

Line 3647: from ar_payment_schedules_all a, iex_delinquencies_all b

3643: order by 1;
3644:
3645: cursor c_cus_dist_inv_cur (p_party_id number,p_org_id number) is
3646: select distinct a.invoice_currency_code
3647: from ar_payment_schedules_all a, iex_delinquencies_all b
3648: where a.payment_schedule_id = b.payment_schedule_id
3649: --and b.status in ('DELINQUENT', 'PREDELINQUENT')
3650: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3651: and a.status = 'OP'

Line 3665: from ar_payment_schedules_all a, iex_delinquencies_all b

3661: and site_use_id is null;
3662:
3663: cursor c_acc_tot_amt_due_rem (p_cust_account_id number, p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3664: select sum(nvl(a.amount_due_remaining,0))
3665: from ar_payment_schedules_all a, iex_delinquencies_all b
3666: where a.payment_schedule_id = b.payment_schedule_id
3667: and b.status in ('DELINQUENT', 'PREDELINQUENT')
3668: AND a.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
3669: and a.status = 'OP'

Line 3705: from iex_delinquencies_all del,

3701: p_corr_date date, p_grace_days number, p_include_dis_items varchar,
3702: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3703: select nvl(sum(amount_due_remaining),0) from (
3704: select arp.amount_due_remaining amount_due_remaining
3705: from iex_delinquencies_all del,
3706: ar_payment_schedules_all arp
3707: where del.payment_schedule_id = arp.payment_schedule_id
3708: and del.status in ('DELINQUENT','PREDELINQUENT')
3709: and del.customer_site_use_id = p_site_use_id

Line 3719: from iex_delinquencies_all del,

3715: and arp.amount_due_remaining >= p_min_dun_inv_amt
3716: and del.org_id = p_org_id
3717: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3718: select arp.amount_due_remaining amount_due_remaining
3719: from iex_delinquencies_all del,
3720: ar_payment_schedules_all arp
3721: where del.payment_schedule_id = arp.payment_schedule_id
3722: and del.status = 'CURRENT'
3723: and del.customer_site_use_id = p_site_use_id

Line 3741: from iex_delinquencies_all del

3737: p_min_days_bw_dun number, p_corr_date date, p_include_dis_items varchar,
3738: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3739: select nvl(sum(amount_due_remaining),0) from (
3740: select arp.amount_due_remaining amount_due_remaining
3741: from iex_delinquencies_all del
3742: ,ar_payment_schedules_all arp
3743: where
3744: del.payment_schedule_id = arp.payment_schedule_id and
3745: del.status in ('DELINQUENT','PREDELINQUENT')

Line 3772: from iex_delinquencies_all del

3768: and arp.amount_due_remaining >= p_min_dun_inv_amt
3769: and del.org_id = p_org_id
3770: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3771: select arp.amount_due_remaining amount_due_remaining
3772: from iex_delinquencies_all del
3773: ,ar_payment_schedules_all arp
3774: where
3775: del.payment_schedule_id = arp.payment_schedule_id and
3776: del.status = 'CURRENT'

Line 3810: from iex_delinquencies_all del,

3806: p_corr_date date, p_grace_days number, p_include_dis_items varchar,
3807: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3808: select nvl(sum(amount_due_remaining),0) from (
3809: select arp.amount_due_remaining amount_due_remaining
3810: from iex_delinquencies_all del,
3811: ar_payment_schedules_all arp
3812: where del.payment_schedule_id = arp.payment_schedule_id
3813: and del.status in ('DELINQUENT','PREDELINQUENT')
3814: and del.cust_account_id = p_cust_acct_id

Line 3824: from iex_delinquencies_all del,

3820: and arp.amount_due_remaining >= p_min_dun_inv_amt
3821: and del.org_id = p_org_id
3822: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3823: select arp.amount_due_remaining amount_due_remaining
3824: from iex_delinquencies_all del,
3825: ar_payment_schedules_all arp
3826: where del.payment_schedule_id = arp.payment_schedule_id
3827: and del.status = 'CURRENT'
3828: and del.cust_account_id = p_cust_acct_id

Line 3846: from iex_delinquencies_all del

3842: p_min_days_bw_dun number, p_corr_date date, p_include_dis_items varchar,
3843: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3844: select nvl(sum(amount_due_remaining),0) from (
3845: select arp.amount_due_remaining amount_due_remaining
3846: from iex_delinquencies_all del
3847: ,ar_payment_schedules_all arp
3848: where
3849: del.payment_schedule_id = arp.payment_schedule_id and
3850: del.status in ('DELINQUENT','PREDELINQUENT')

Line 3879: from iex_delinquencies_all del

3875: and arp.amount_due_remaining >= p_min_dun_inv_amt
3876: and del.org_id = p_org_id
3877: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3878: select arp.amount_due_remaining amount_due_remaining
3879: from iex_delinquencies_all del
3880: ,ar_payment_schedules_all arp
3881: where
3882: del.payment_schedule_id = arp.payment_schedule_id and
3883: del.status = 'CURRENT'

Line 3917: from iex_delinquencies_all del,

3913: p_corr_date date, p_grace_days number, p_include_dis_items varchar,
3914: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3915: select nvl(sum(amount_due_remaining),0) from (
3916: select arp.amount_due_remaining amount_due_remaining
3917: from iex_delinquencies_all del,
3918: ar_payment_schedules_all arp
3919: where del.payment_schedule_id = arp.payment_schedule_id
3920: and del.status in ('DELINQUENT','PREDELINQUENT')
3921: and del.party_cust_id = p_party_id

Line 3931: from iex_delinquencies_all del,

3927: and arp.amount_due_remaining >= p_min_dun_inv_amt
3928: and del.org_id = p_org_id
3929: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3930: select arp.amount_due_remaining amount_due_remaining
3931: from iex_delinquencies_all del,
3932: ar_payment_schedules_all arp
3933: where del.payment_schedule_id = arp.payment_schedule_id
3934: and del.status = 'CURRENT'
3935: and del.party_cust_id = p_party_id

Line 3953: from iex_delinquencies_all del

3949: p_min_days_bw_dun number, p_corr_date date, p_include_dis_items varchar,
3950: p_currency_code varchar, p_min_dun_inv_amt number,p_org_id number) is
3951: select nvl(sum(amount_due_remaining),0) from (
3952: select arp.amount_due_remaining amount_due_remaining
3953: from iex_delinquencies_all del
3954: ,ar_payment_schedules_all arp
3955: where
3956: del.payment_schedule_id = arp.payment_schedule_id and
3957: del.status in ('DELINQUENT','PREDELINQUENT')

Line 3986: from iex_delinquencies_all del

3982: and arp.amount_due_remaining >= p_min_dun_inv_amt
3983: and del.org_id = p_org_id
3984: union all --Added for Bug 10401991 03-Feb-2011 barathsr
3985: select arp.amount_due_remaining amount_due_remaining
3986: from iex_delinquencies_all del
3987: ,ar_payment_schedules_all arp
3988: where
3989: del.payment_schedule_id = arp.payment_schedule_id and
3990: del.status = 'CURRENT'

Line 4032: from ar_payment_schedules_all aps,iex_delinquencies_all dd

4028:
4029: --Begin Bug 10401991 14-Feb-2011 barathsr
4030: cursor c_acct_tot_acctd_amt_rem (p_cust_account_id number,p_org_id number) is
4031: select nvl(sum(aps.acctd_amount_due_remaining),0)
4032: from ar_payment_schedules_all aps,iex_delinquencies_all dd
4033: where dd.payment_schedule_id = aps.payment_schedule_id
4034: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
4035: and aps.status='OP'
4036: and aps.customer_id=p_cust_account_id

Line 4051: from ar_payment_schedules_all aps,iex_delinquencies_all dd

4047: and org_id = p_org_id;
4048:
4049: cursor c_billto_tot_acctd_amt_rem (p_site_use_id number,p_org_id number) is
4050: select nvl(sum(aps.acctd_amount_due_remaining),0)
4051: from ar_payment_schedules_all aps,iex_delinquencies_all dd
4052: where dd.payment_schedule_id = aps.payment_schedule_id
4053: and aps.class IN ('INV', 'GUAR', 'CB', 'DM', 'DEP', 'BR') -- Bills Receivables change
4054: and aps.status='OP'
4055: and aps.customer_site_use_id=p_site_use_id

Line 4603: iex_delinquencies_all del

4599: select max(iet.stage_number)
4600: into l_stage_number
4601: from iex_dunning_transactions iet,
4602: iex_dunnings dunn,
4603: iex_delinquencies_all del
4604: where iet.payment_schedule_id = del.payment_schedule_id
4605: and del.delinquency_id = p_delinquency_id
4606: and dunn.dunning_id = iet.dunning_id
4607: and ((dunn.dunning_mode = 'DRAFT' and dunn.confirmation_mode = 'CONFIRMED')

Line 5497: from iex_delinquencies_all del,ra_customer_trx_lines_all trl

5493: iex_debug_pub.logmessage ('p_contract_number :' || p_contract_number);
5494:
5495: IF p_contract_number IS NOT NULL then
5496: select count(1) into l_count
5497: from iex_delinquencies_all del,ra_customer_trx_lines_all trl
5498: where del.TRANSACTION_ID = trl.CUSTOMER_TRX_ID
5499: and del.status not in ('CURRENT', 'CLOSE')
5500: and trl.INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS'
5501: and trl.INTERFACE_LINE_ATTRIBUTE6 = p_contract_number;

Line 5648: from iex_delinquencies_all

5644: from IEX_QUESTIONNAIRE_ITEMS;
5645:
5646: cursor c_unique_ous(p_partyid number) is
5647: select distinct org_id
5648: from iex_delinquencies_all
5649: where status in ('DELINQUENT','PREDELINQUENT')
5650: and party_cust_id=p_partyid;
5651:
5652: l_org_id number;