1977:
1978: l_applied_payment_schedule_id := p_applied_payment_schedule_id;
1979: l_apply_date := p_apply_date;
1980:
1981: /* 9928090/12662193 - made ra_terms an outer join so credit memos
1982: would work properly and not get zeroed out */
1983: select ps.customer_id,
1984: ps.customer_site_use_id,
1985: ps.term_id,
2012: l_amount_line_items_original,
2013: l_partial_discount_flag
2014: from ar_payment_schedules ps,
2015: ra_cust_trx_types ctt,
2016: ra_terms rt
2017: where ps.payment_schedule_id = l_applied_payment_schedule_id
2018: AND ps.cust_trx_type_id = ctt.cust_trx_type_id
2019: AND ps.term_id = rt.term_id (+);
2020: