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.OKL_CURE_CALC_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 147: from ar_payment_schedules ps1,

143:
144:
145: /*cursor c_get_received_amounts (p_cure_amount_id IN NUMBER) is
146: select sum(ara.amount_applied)
147: from ar_payment_schedules ps1,
148: okl_cnsld_ar_strms_b st1
149: ,ar_receivable_applications ara
150: ,okl_xtl_sell_invs_v xls
151: ,okl_txl_ar_inv_lns_v til

Line 163: from ar_payment_schedules ps1,

159: and st1.khr_id =tai.khr_id;*/
160:
161: cursor c_get_received_amounts (p_cure_amount_id IN NUMBER) is
162: select sum(ara.amount_applied)
163: from ar_payment_schedules ps1,
164: okl_bpd_tld_ar_lines_v st1
165: ,ar_receivable_applications ara
166: --,okl_xtl_sell_invs_v xls
167: ,okl_txl_ar_inv_lns_v til

Line 511: ,ar_payment_schedules aps

507: /*CURSOR c_amount_past_due(p_contract_id IN NUMBER,
508: p_grace_days IN NUMBER) IS
509: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
510: FROM okl_cnsld_ar_strms_b ocas
511: ,ar_payment_schedules aps
512: WHERE ocas.khr_id = p_contract_id
513: AND ocas.receivables_invoice_id = aps.customer_trx_id
514: AND aps.class ='INV'
515: AND (aps.due_date + p_grace_days) < sysdate

Line 532: ,ar_payment_schedules aps

528: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
529: p_grace_days IN NUMBER) IS
530: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
531: FROM okl_bpd_tld_ar_lines_v ocas
532: ,ar_payment_schedules aps
533: WHERE ocas.khr_id = p_contract_id
534: AND ocas.customer_trx_id = aps.customer_trx_id
535: AND aps.class ='INV'
536: AND (aps.due_date + p_grace_days) < sysdate

Line 641: ,ar_payment_schedules aps

637: /*CURSOR c_amount_past_due(p_contract_id IN NUMBER,
638: p_grace_days IN NUMBER) IS
639: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
640: FROM okl_cnsld_ar_strms_b ocas
641: ,ar_payment_schedules aps
642: WHERE ocas.khr_id = p_contract_id
643: AND ocas.receivables_invoice_id = aps.customer_trx_id
644: AND aps.class ='INV'
645: AND (aps.due_date + p_grace_days) < sysdate

Line 662: ,ar_payment_schedules aps

658: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
659: p_grace_days IN NUMBER) IS
660: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
661: FROM okl_bpd_tld_ar_lines_v ocas
662: ,ar_payment_schedules aps
663: WHERE ocas.khr_id = p_contract_id
664: AND ocas.customer_trx_id = aps.customer_trx_id
665: AND aps.class ='INV'
666: AND (aps.due_date + p_grace_days) < sysdate

Line 1154: ,ar_payment_schedules aps

1150: /*CURSOR c_amount_past_due(p_contract_id IN NUMBER,
1151: p_grace_days IN NUMBER) IS
1152: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
1153: FROM okl_cnsld_ar_strms_b ocas
1154: ,ar_payment_schedules aps
1155: WHERE ocas.khr_id = p_contract_id
1156: AND ocas.receivables_invoice_id = aps.customer_trx_id
1157: AND aps.class ='INV'
1158: AND (aps.due_date + p_grace_days) < sysdate

Line 1175: ,ar_payment_schedules aps

1171: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
1172: p_grace_days IN NUMBER) IS
1173: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
1174: FROM okl_bpd_tld_ar_lines_v ocas
1175: ,ar_payment_schedules aps
1176: WHERE ocas.khr_id = p_contract_id
1177: AND ocas.customer_trx_id = aps.customer_trx_id
1178: AND aps.class ='INV'
1179: AND (aps.due_date + p_grace_days) < sysdate

Line 1313: from ar_payment_schedules ps

1309:
1310:
1311: /*cursor c_get_noof_cures(p_contract_id IN NUMBER) is
1312: select count( ps.payment_schedule_id)
1313: from ar_payment_schedules ps
1314: ,okl_cnsld_ar_strms_b stream
1315: ,okl_xtl_sell_invs_v xls
1316: ,okl_txl_ar_inv_lns_v til
1317: ,okl_trx_ar_invoices_v tai

Line 1330: from ar_payment_schedules ps

1326:
1327: cursor c_get_noof_cures(p_contract_id IN NUMBER)
1328: is
1329: select count( ps.payment_schedule_id)
1330: from ar_payment_schedules ps
1331: ,okl_bpd_tld_ar_lines_v stream
1332: --,okl_xtl_sell_invs_v xls
1333: ,okl_txd_ar_ln_dtls_b tld
1334: ,okl_txl_ar_inv_lns_v til

Line 1360: ,ar_payment_schedules aps

1356:
1357: /*cursor l_days_past_due_cur (p_contract_id IN NUMBER) is
1358: SELECT min(aps.due_date)
1359: FROM okl_cnsld_ar_strms_b ocas
1360: ,ar_payment_schedules aps
1361: ,okc_k_headers_b chr
1362: ,OKL_STRM_TYPE_TL SM
1363: WHERE
1364: ocas.khr_id = p_contract_id

Line 1376: ,ar_payment_schedules aps

1372: cursor l_days_past_due_cur (p_contract_id IN NUMBER)
1373: is
1374: SELECT min(aps.due_date)
1375: FROM okl_bpd_tld_ar_lines_v ocas
1376: ,ar_payment_schedules aps
1377: ,okc_k_headers_b chr
1378: ,OKL_STRM_TYPE_TL SM
1379: WHERE ocas.khr_id = p_contract_id
1380: AND ocas.customer_trx_id = aps.customer_trx_id