DBA Data[Home] [Help]

APPS.ARP_CASH_BASIS_JE_REPORT dependencies on RA_TERMS

Line 413: ra_terms t,

409: l_currency_code,
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

Line 414: ra_terms_lines tl,

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

Line 415: ra_terms_lines tl_first

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