410: l_AmountReconcile,
411: l_FirstInstallmentFlag
412: FROM ar_payment_schedules ps,
413: ra_terms t,
414: ra_terms_lines tl,
415: ra_terms_lines tl_first
416: WHERE ps.payment_schedule_id = p_ps_id
417: AND tl.term_id(+) = ps.term_id
418: AND tl.sequence_num(+) = ps.terms_sequence_number
411: l_FirstInstallmentFlag
412: FROM ar_payment_schedules ps,
413: ra_terms t,
414: ra_terms_lines tl,
415: ra_terms_lines tl_first
416: WHERE ps.payment_schedule_id = p_ps_id
417: AND tl.term_id(+) = ps.term_id
418: AND tl.sequence_num(+) = ps.terms_sequence_number
419: AND t.term_id(+) = tl.term_id