APPS.FV_APPLY_CASH_RECEIPT dependencies on RA_TERMS

Line 2113: ra_terms t,

2109: BEGIN
2110: SELECT ctl.extended_amount * nvl(tl.relative_amount,1)/ nvl(t.base_amount,1) original_line_amount
2111: INTO l_LineAmount
2112: FROM ra_customer_trx_lines ctl ,
2113: ra_terms t,
2114: ra_terms_lines tl,
2115: ar_payment_schedules ps
2116: WHERE ps.payment_schedule_id = p_PaymentScheduleId
2117: AND ctl.customer_trx_id = p_InvoiceId

Line 2114: ra_terms_lines tl,

2110: SELECT ctl.extended_amount * nvl(tl.relative_amount,1)/ nvl(t.base_amount,1) original_line_amount
2111: INTO l_LineAmount
2112: FROM ra_customer_trx_lines ctl ,
2113: ra_terms t,
2114: ra_terms_lines tl,
2115: ar_payment_schedules ps
2116: WHERE ps.payment_schedule_id = p_PaymentScheduleId
2117: AND ctl.customer_trx_id = p_InvoiceId
2118: AND ctl.line_type = 'LINE'

Line 2130: p_ErrorLoc := 'SELECT ra_customer_trx_lines, ra_terms...';

2126: debug_msg (l_module_name, 'No Data Found for payment_schedule_id <'||p_PaymentScheduleId||'>');
2127: WHEN OTHERS THEN
2128: p_ErrorCode := g_FAILURE;
2129: p_ErrorDesc := SQLERRM;
2130: p_ErrorLoc := 'SELECT ra_customer_trx_lines, ra_terms...';
2131: error
2132: (
2133: p_error_type => p_ErrorCode,
2134: p_pgm => l_module_name,