DBA Data[Home] [Help]

APPS.JA_JAINVATR_XMLP_PKG dependencies on JAI_RCV_RGM_LINES

Line 182: JAI_RCV_RGM_LINES JRRL

178: CURSOR LCU_CG_TAX_CLAIMED IS
179: SELECT
180: SUM(JRRL.RECOVERED_AMOUNT)
181: FROM
182: JAI_RCV_RGM_LINES JRRL
183: WHERE JRRL.REGIME_ITEM_CLASS = 'CG'
184: AND JRRL.ORGANIZATION_ID = A_ORGANIZATION_ID
185: AND JRRL.LOCATION_ID = A_LOCATION_ID
186: AND TRUNC(JRRL.RECEIPT_DATE) BETWEEN P_FROM_DATE