APPS.ARP_CALCULATE_DISCOUNT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 952: FROM AR_RECEIVABLE_APPLICATIONS

948: BEGIN
949: SELECT nvl(sum(line_applied),0), sum(amount_applied),
950: nvl(sum(tax_applied),0)
951: INTO l_line_applied, l_amount_applied, l_tax_line_applied
952: FROM AR_RECEIVABLE_APPLICATIONS
953: WHERE application_type = 'CM'
954: AND applied_payment_schedule_id = p_ps_rec.payment_schedule_id
955: AND status = 'APP'
956: AND application_rule in ('65','66','67');

Line 1287: FROM AR_RECEIVABLE_APPLICATIONS

1283: --
1284: BEGIN
1285: SELECT sum(amount_applied)
1286: INTO l_amount_applied
1287: FROM AR_RECEIVABLE_APPLICATIONS
1288: WHERE application_type = 'CM'
1289: AND applied_payment_schedule_id = p_ps_rec.payment_schedule_id
1290: AND status = 'APP'
1291: AND application_rule in ('65','66','67');

Line 1522: from ar_receivable_applications

1518: nvl(sum(earned_discount_taken),0),
1519: nvl(sum(unearned_discount_taken),0)
1520: into l_amount_applied_to, l_earned_discount_taken,
1521: l_unearned_discount_taken
1522: from ar_receivable_applications
1523: where applied_payment_schedule_id =
1524: p_ps_rec.payment_schedule_id
1525: and application_type = 'CASH'
1526: and status = 'APP';