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_BUS_EVENT_SUB_PVT dependencies on AR_PAYMENT_SCHEDULES

Line 129: l_cust_account_id ar_payment_schedules.customer_id%type;

125: l_receipt_number VARCHAR2(30);
126: l_customer_id NUMBER;
127: l_customer_site_use_id NUMBER;
128: l_currency_code VARCHAR2(30);
129: l_cust_account_id ar_payment_schedules.customer_id%type;
130: l_security_gr_id NUMBER;
131:
132: x_return_status VARCHAR2(30);
133: BEGIN

Line 561: TYPE ps_tab_type IS TABLE OF ar_payment_schedules%rowtype

557: ,trx_type IN VARCHAR2
558: )
559: RETURN VARCHAR2 IS
560: l_customer_trx_id NUMBER;
561: TYPE ps_tab_type IS TABLE OF ar_payment_schedules%rowtype
562: INDEX BY BINARY_INTEGER;
563: l_ps_tab ps_tab_type;
564: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
565:

Line 567: SELECT * from ar_payment_schedules

563: l_ps_tab ps_tab_type;
564: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
565:
566: CURSOR select_ps (cust_trx_id IN NUMBER) IS
567: SELECT * from ar_payment_schedules
568: WHERE customer_trx_id = cust_trx_id;
569:
570: CURSOR select_ps_rec (l_payment_schedule_id IN NUMBER) IS
571: SELECT * from ar_payment_schedules

Line 571: SELECT * from ar_payment_schedules

567: SELECT * from ar_payment_schedules
568: WHERE customer_trx_id = cust_trx_id;
569:
570: CURSOR select_ps_rec (l_payment_schedule_id IN NUMBER) IS
571: SELECT * from ar_payment_schedules
572: WHERE payment_schedule_id = l_payment_schedule_id;
573:
574: CURSOR select_ps_cm (p_ra_id IN NUMBER ) IS
575: SELECT trx_ps.*

Line 576: FROM ar_payment_schedules trx_ps,

572: WHERE payment_schedule_id = l_payment_schedule_id;
573:
574: CURSOR select_ps_cm (p_ra_id IN NUMBER ) IS
575: SELECT trx_ps.*
576: FROM ar_payment_schedules trx_ps,
577: ar_receivable_applications ra,
578: ar_payment_schedules rcpt_ps
579: WHERE ra.receivable_application_id = p_ra_id
580: AND ra.status in ('APP')

Line 578: ar_payment_schedules rcpt_ps

574: CURSOR select_ps_cm (p_ra_id IN NUMBER ) IS
575: SELECT trx_ps.*
576: FROM ar_payment_schedules trx_ps,
577: ar_receivable_applications ra,
578: ar_payment_schedules rcpt_ps
579: WHERE ra.receivable_application_id = p_ra_id
580: AND ra.status in ('APP')
581: AND ra.payment_schedule_id = rcpt_ps.payment_schedule_id
582: AND ra.applied_payment_schedule_id = trx_ps.payment_schedule_id;

Line 587: ar_payment_schedules ps

583:
584: CURSOR select_ps_adj (p_adj_id IN NUMBER) IS
585: SELECT ps.*
586: FROM ar_adjustments adj,
587: ar_payment_schedules ps
588: WHERE adj.payment_schedule_id = ps.payment_schedule_id
589: and adj.adjustment_id = p_adj_id ;
590:
591: CURSOR select_ps_auto_adj (p_req_id IN NUMBER) IS

Line 594: ar_payment_schedules ps

590:
591: CURSOR select_ps_auto_adj (p_req_id IN NUMBER) IS
592: SELECT ps.*
593: FROM ar_adjustments adj,
594: ar_payment_schedules ps
595: WHERE adj.request_id = p_req_id
596: and adj.payment_schedule_id = ps.payment_schedule_id;
597:
598:

Line 602: ar_payment_schedules ps

598:
599: CURSOR select_ps_auto_rec (p_request_id IN NUMBER) IS
600: SELECT ps.*
601: FROM ar_receivable_applications ra,
602: ar_payment_schedules ps
603: WHERE ra.request_id = p_request_id
604: AND ra.status IN('APP','UNAPP')
605: AND ps.payment_schedule_id = ra.applied_payment_schedule_id;
606:

Line 610: ar_payment_schedules ps

606:
607: CURSOR select_ps_auto_inv (p_request_id IN NUMBER) IS
608: SELECT ps.*
609: FROM ra_customer_trx trx,
610: ar_payment_schedules ps
611: WHERE
612: trx.customer_trx_id = ps.customer_trx_id
613: AND trx.request_id = p_request_id;
614:

Line 640: ar_payment_schedules_all b

636: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
637: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
638: (SELECT SUM(b.acctd_amount_due_remaining)
639: FROM iex_delinquencies_all a,
640: ar_payment_schedules_all b
641: WHERE a.customer_site_use_id = trx_summ.site_use_id
642: AND a.payment_schedule_id = b.payment_schedule_id
643: AND b.status = 'OP'
644: AND a.status IN('DELINQUENT', 'PREDELINQUENT')) past_due_inv_value,

Line 710: ar_payment_schedules_all b

706: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
707: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
708: (SELECT SUM(b.acctd_amount_due_remaining)
709: FROM iex_delinquencies_all a,
710: ar_payment_schedules_all b
711: WHERE a.cust_account_id = trx_summ.cust_account_id
712: AND a.payment_schedule_id = b.payment_schedule_id
713: AND b.status = 'OP'
714: AND a.status IN('DELINQUENT', 'PREDELINQUENT')) past_due_inv_value,

Line 780: ar_payment_schedules_all b

776: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
777: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
778: (SELECT SUM(b.acctd_amount_due_remaining)
779: FROM iex_delinquencies_all a,
780: ar_payment_schedules_all b
781: WHERE a.party_cust_id = party.party_id
782: AND a.payment_schedule_id = b.payment_schedule_id
783: AND b.status = 'OP'
784: AND a.status IN('DELINQUENT', 'PREDELINQUENT')) past_due_inv_value,