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 131: l_cust_account_id ar_payment_schedules.customer_id%type;

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

Line 565: TYPE ps_tab_type IS TABLE OF ar_payment_schedules%rowtype

561: ,trx_type IN VARCHAR2
562: )
563: RETURN VARCHAR2 IS
564: l_customer_trx_id NUMBER;
565: TYPE ps_tab_type IS TABLE OF ar_payment_schedules%rowtype
566: INDEX BY BINARY_INTEGER;
567: l_ps_tab ps_tab_type;
568: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
569:

Line 571: SELECT * from ar_payment_schedules

567: l_ps_tab ps_tab_type;
568: l_trx_summary_hist AR_TRX_SUMMARY_HIST%rowtype;
569:
570: CURSOR select_ps (cust_trx_id IN NUMBER) IS
571: SELECT * from ar_payment_schedules
572: WHERE customer_trx_id = cust_trx_id;
573:
574: CURSOR select_ps_rec (l_payment_schedule_id IN NUMBER) IS
575: SELECT * from ar_payment_schedules

Line 575: SELECT * from ar_payment_schedules

571: SELECT * from ar_payment_schedules
572: WHERE customer_trx_id = cust_trx_id;
573:
574: CURSOR select_ps_rec (l_payment_schedule_id IN NUMBER) IS
575: SELECT * from ar_payment_schedules
576: WHERE payment_schedule_id = l_payment_schedule_id;
577:
578: CURSOR select_ps_cm (p_ra_id IN NUMBER ) IS
579: SELECT trx_ps.*

Line 580: FROM ar_payment_schedules trx_ps,

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

Line 582: ar_payment_schedules rcpt_ps

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

Line 591: ar_payment_schedules ps

587:
588: CURSOR select_ps_adj (p_adj_id IN NUMBER) IS
589: SELECT ps.*
590: FROM ar_adjustments adj,
591: ar_payment_schedules ps
592: WHERE adj.payment_schedule_id = ps.payment_schedule_id
593: and adj.adjustment_id = p_adj_id ;
594:
595: CURSOR select_ps_auto_adj (p_req_id IN NUMBER) IS

Line 598: ar_payment_schedules ps

594:
595: CURSOR select_ps_auto_adj (p_req_id IN NUMBER) IS
596: SELECT ps.*
597: FROM ar_adjustments adj,
598: ar_payment_schedules ps
599: WHERE adj.request_id = p_req_id
600: and adj.payment_schedule_id = ps.payment_schedule_id;
601:
602:

Line 606: ar_payment_schedules ps

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

Line 614: ar_payment_schedules ps

610:
611: CURSOR select_ps_auto_inv (p_request_id IN NUMBER) IS
612: SELECT ps.*
613: FROM ra_customer_trx trx,
614: ar_payment_schedules ps
615: WHERE
616: trx.customer_trx_id = ps.customer_trx_id
617: AND trx.request_id = p_request_id;
618: --begin mls

Line 651: ar_payment_schedules_all b

647: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
648: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
649: (SELECT SUM(b.acctd_amount_due_remaining)
650: FROM iex_delinquencies_all a,
651: ar_payment_schedules_all b
652: WHERE a.customer_site_use_id = trx_summ.site_use_id
653: AND a.payment_schedule_id = b.payment_schedule_id
654: AND b.status = 'OP'
655: AND a.status IN('DELINQUENT', 'PREDELINQUENT')) past_due_inv_value,

Line 721: ar_payment_schedules_all b

717: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
718: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
719: (SELECT SUM(b.acctd_amount_due_remaining)
720: FROM iex_delinquencies_all a,
721: ar_payment_schedules_all b
722: WHERE a.cust_account_id = trx_summ.cust_account_id
723: AND a.payment_schedule_id = b.payment_schedule_id
724: AND b.status = 'OP'
725: AND a.status IN('DELINQUENT', 'PREDELINQUENT')) past_due_inv_value,

Line 791: ar_payment_schedules_all b

787: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
788: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
789: (SELECT SUM(b.acctd_amount_due_remaining)
790: FROM iex_delinquencies_all a,
791: ar_payment_schedules_all b
792: WHERE a.party_cust_id = party.party_id
793: AND a.payment_schedule_id = b.payment_schedule_id
794: AND b.status = 'OP'
795: AND a.status IN('DELINQUENT', 'PREDELINQUENT')) past_due_inv_value,