DBA Data[Home] [Help]

APPS.JA_JAINRECI_XMLP_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 265: JAI_CMN_RG_23AC_II_TRXS RG

261: WHERE JRO.SOURCE_REGISTER_ID IN (
262: SELECT
263: RG.REGISTER_ID
264: FROM
265: JAI_CMN_RG_23AC_II_TRXS RG
266: WHERE RG.RECEIPT_REF = TRANSACTION_ID
267: AND RG.ORGANIZATION_ID = ORGANIZATION_ID1
268: AND RG.TRANSACTION_SOURCE_NUM = 18
269: AND RG.LOCATION_ID = cf_cess_amountformula.LOCATION_ID )

Line 329: JAI_CMN_RG_23AC_II_TRXS

325: - NVL(CR_ADDITIONAL_CVD
326: ,0) + NVL(DR_ADDITIONAL_CVD
327: ,0) OTHER_ED
328: FROM
329: JAI_CMN_RG_23AC_II_TRXS
330: WHERE REGISTER_ID = CP_REGISTER_ID;
331: CURSOR C_PLA_RND_AMTS(CP_REGISTER_ID IN NUMBER) IS
332: SELECT
333: - NVL(CR_BASIC_ED

Line 504: JAI_CMN_RG_23AC_II_TRXS RG

500: WHERE JRO.SOURCE_REGISTER_ID in (
501: SELECT
502: RG.REGISTER_ID
503: FROM
504: JAI_CMN_RG_23AC_II_TRXS RG
505: WHERE RG.RECEIPT_REF = TRANSACTION_ID
506: AND RG.ORGANIZATION_ID = ORGANIZATION_ID1
507: AND RG.TRANSACTION_SOURCE_NUM = 18
508: AND RG.LOCATION_ID = cf_sh_cess_amountformula.LOCATION_ID )