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 1058: ) rc, ar_payment_schedules ps

1054: from ( select customer_trx_id
1055: from ra_customer_trx_lines rct
1056: start with br_ref_customer_trx_id = p_customer_trx_id
1057: connect by prior customer_trx_id = br_ref_customer_trx_id
1058: ) rc, ar_payment_schedules ps
1059: where ps.customer_trx_id = rc.customer_trx_id
1060: and ps.status = 'OP'
1061: and ps.customer_trx_id <> g_orig_cust_trx_id
1062: );

Line 1140: ar_payment_schedules pay

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

Line 1156: ar_payment_schedules pay

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

Line 1616: l_pay_class ar_payment_schedules.class%TYPE;

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

Line 1872: from ar_payment_schedules pay

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