DBA Data[Home] [Help]

APPS.JAI_CMN_TAX_DEFAULTATION_PKG dependencies on JAI_RETRO_LINE_CHANGES

Line 2003: Jai_Retro_Line_Changes jrlc

1999: WHERE jrtc.tax_id = rec.tax_id
2000: AND jrtc.line_change_id = (SELECT
2001: line_change_id
2002: FROM
2003: Jai_Retro_Line_Changes jrlc
2004: WHERE jrlc.line_location_id = lv_line_loc_id
2005: AND jrlc.doc_type IN ( 'RELEASE'
2006: , 'RECEIPT'
2007: , 'STANDARD PO'

Line 2012: Jai_Retro_Line_Changes jrlc1

2008: )
2009: AND jrlc.doc_version_number = (SELECT
2010: MAX(jrlc1.doc_version_number)
2011: FROM
2012: Jai_Retro_Line_Changes jrlc1
2013: WHERE jrlc1.line_location_id = lv_line_loc_id
2014: AND jrlc1.doc_type IN ( 'RELEASE'
2015: , 'RECEIPT'
2016: , 'STANDARD PO'