APPS.ARP_RECONCILE dependencies on AR_PAYMENT_SCHEDULES

Line 184: l_pay_class ar_payment_schedules.class%TYPE;

180:
181: l_ae_sys_rec ae_sys_rec_type;
182: l_closed_pymt_yn VARCHAR2(1);
183: l_calling_point VARCHAR2(4);
184: l_pay_class ar_payment_schedules.class%TYPE;
185: l_required BOOLEAN;
186:
187: BEGIN
188:

Line 1054: from ar_payment_schedules ps

1050: select 'N'
1051: into p_all_br_closed
1052: from dual
1053: where exists( select 'x'
1054: from ar_payment_schedules ps
1055: where ps.customer_trx_id in (
1056: select customer_trx_id
1057: from ra_customer_trx_lines
1058: start with br_ref_customer_trx_id = p_customer_trx_id

Line 1141: ar_payment_schedules pay

1137: sum(nvl(app.receivables_charges_applied,0) +
1138: nvl(app.charges_ediscounted,0) +
1139: nvl(app.charges_uediscounted,0)) receivables_charges_amount
1140: FROM ar_receivable_applications app,
1141: ar_payment_schedules pay
1142: WHERE app.applied_customer_trx_id = p_customer_trx_id
1143: AND app.status = 'APP'
1144: AND nvl(app.confirmed_flag, 'Y') = 'Y'
1145: AND app.applied_payment_schedule_id = pay.payment_schedule_id

Line 1157: ar_payment_schedules pay

1153: sum(nvl(adj.tax_adjusted,0) * -1) tax_amount,
1154: sum(nvl(adj.freight_adjusted,0) * -1) freight_amount,
1155: sum(nvl(adj.receivables_charges_adjusted,0) * -1) receivables_charges_amount
1156: FROM ar_adjustments adj,
1157: ar_payment_schedules pay
1158: WHERE adj.customer_trx_id = p_customer_trx_id
1159: AND adj.payment_schedule_id = pay.payment_schedule_id
1160: AND adj.status = 'A'
1161: GROUP by pay.payment_schedule_id;

Line 1617: l_pay_class ar_payment_schedules.class%TYPE;

1613: l_app_rec ar_receivable_applications%ROWTYPE;
1614:
1615: --The bill closed flag is defaulted to N
1616: l_all_br_closed VARCHAR2(1) := 'N';
1617: l_pay_class ar_payment_schedules.class%TYPE;
1618: l_closed_pymt_yn VARCHAR2(1);
1619:
1620: l_required BOOLEAN;
1621:

Line 1873: from ar_payment_schedules pay

1869: max(pay.class)
1870: into l_amount_due_remaining,
1871: l_acctd_amount_due_remaining,
1872: p_pay_class
1873: from ar_payment_schedules pay
1874: where pay.customer_trx_id = p_customer_trx_id;
1875: END IF;
1876: IF PG_DEBUG in ('Y', 'C') THEN
1877: arp_standard.debug('Detect_Closure: ' || 'p_customer_trx_id ' || p_customer_trx_id);