eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_JAINRECI_XMLP_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 248: JAI_CMN_RG_PLA_TRXS RG

244: WHERE JRO.SOURCE_REGISTER_ID IN (
245: SELECT
246: RG.REGISTER_ID
247: FROM
248: JAI_CMN_RG_PLA_TRXS RG
249: WHERE RG.REF_DOCUMENT_ID = TRANSACTION_ID
250: AND RG.ORGANIZATION_ID = ORGANIZATION_ID1
251: AND RG.TRANSACTION_SOURCE_NUM = 19
252: AND RG.LOCATION_ID = cf_cess_amountformula.LOCATION_ID )

Line 343: JAI_CMN_RG_PLA_TRXS

339: - NVL(CR_OTHER_ED
340: ,0) + NVL(DR_OTHER_ED
341: ,0) OTHER_ED
342: FROM
343: JAI_CMN_RG_PLA_TRXS
344: WHERE REGISTER_ID = CP_REGISTER_ID;
345: LV_EXC_EDU_CESS JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;
346: LV_CVD_EDU_CESS JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;
347: CURSOR C_RND_CESS_AMT(CP_REGISTER_ID IN NUMBER,CP_SOURCE_TYPE IN NUMBER) IS

Line 487: JAI_CMN_RG_PLA_TRXS RG

483: WHERE JRO.SOURCE_REGISTER_ID in (
484: SELECT
485: RG.REGISTER_ID
486: FROM
487: JAI_CMN_RG_PLA_TRXS RG
488: WHERE RG.REF_DOCUMENT_ID = TRANSACTION_ID
489: AND RG.ORGANIZATION_ID = ORGANIZATION_ID1
490: AND RG.TRANSACTION_SOURCE_NUM = 19
491: AND RG.LOCATION_ID = cf_sh_cess_amountformula.LOCATION_ID )