APPS.ARP_CALCULATE_DISCOUNT dependencies on AR_RECEIVABLE_APPLICATIONS

Line 956: FROM AR_RECEIVABLE_APPLICATIONS

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

Line 1291: FROM AR_RECEIVABLE_APPLICATIONS

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

Line 1531: from ar_receivable_applications

1527: nvl(sum(earned_discount_taken),0),
1528: nvl(sum(unearned_discount_taken),0)
1529: into l_amount_applied_to, l_earned_discount_taken,
1530: l_unearned_discount_taken
1531: from ar_receivable_applications
1532: where applied_payment_schedule_id =
1533: p_ps_rec.payment_schedule_id
1534: and application_type = 'CASH'
1535: and status = 'APP';