APPS.JA_JAINRECI_XMLP_PKG dependencies on JAI_CMN_RG_OTHERS

Line 236: LV_EXC_EDU_CESS JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;

232: ,DR_BASIC_ED IN NUMBER
233: ,DR_ADDITIONAL_ED IN NUMBER
234: ,DR_OTHER_ED IN NUMBER) RETURN NUMBER IS
235: LN_CESS_AMOUNT NUMBER;
236: LV_EXC_EDU_CESS JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;
237: LV_CVD_EDU_CESS JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;
238: CURSOR LCU_GET_PLA_CESS_AMOUNT IS
239: SELECT
240: NVL(SUM(JRO.CREDIT)

Line 237: LV_CVD_EDU_CESS JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;

233: ,DR_ADDITIONAL_ED IN NUMBER
234: ,DR_OTHER_ED IN NUMBER) RETURN NUMBER IS
235: LN_CESS_AMOUNT NUMBER;
236: LV_EXC_EDU_CESS JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;
237: LV_CVD_EDU_CESS JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;
238: CURSOR LCU_GET_PLA_CESS_AMOUNT IS
239: SELECT
240: NVL(SUM(JRO.CREDIT)
241: ,SUM(JRO.DEBIT))

Line 243: JAI_CMN_RG_OTHERS JRO

239: SELECT
240: NVL(SUM(JRO.CREDIT)
241: ,SUM(JRO.DEBIT))
242: FROM
243: JAI_CMN_RG_OTHERS JRO
244: WHERE JRO.SOURCE_REGISTER_ID IN (
245: SELECT
246: RG.REGISTER_ID
247: FROM

Line 260: JAI_CMN_RG_OTHERS JRO

256: SELECT
257: NVL(SUM(JRO.CREDIT)
258: ,SUM(JRO.DEBIT))
259: FROM
260: JAI_CMN_RG_OTHERS JRO
261: WHERE JRO.SOURCE_REGISTER_ID IN (
262: SELECT
263: RG.REGISTER_ID
264: FROM

Line 345: LV_EXC_EDU_CESS JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;

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
348: SELECT
349: SUM(NVL(DEBIT

Line 346: LV_CVD_EDU_CESS JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;

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
348: SELECT
349: SUM(NVL(DEBIT
350: ,0) - NVL(CREDIT

Line 353: JAI_CMN_RG_OTHERS

349: SUM(NVL(DEBIT
350: ,0) - NVL(CREDIT
351: ,0))
352: FROM
353: JAI_CMN_RG_OTHERS
354: WHERE SOURCE_REGISTER_ID = CP_REGISTER_ID
355: AND SOURCE_TYPE = CP_SOURCE_TYPE
356: AND TAX_TYPE in ( LV_EXC_EDU_CESS , LV_CVD_EDU_CESS );
357: V_RND_BASIC_ED NUMBER;

Line 482: JAI_CMN_RG_OTHERS JRO

478: SELECT
479: NVL(SUM(JRO.CREDIT)
480: ,SUM(JRO.DEBIT))
481: FROM
482: JAI_CMN_RG_OTHERS JRO
483: WHERE JRO.SOURCE_REGISTER_ID in (
484: SELECT
485: RG.REGISTER_ID
486: FROM

Line 499: JAI_CMN_RG_OTHERS JRO

495: SELECT
496: NVL(SUM(JRO.CREDIT)
497: ,SUM(JRO.DEBIT))
498: FROM
499: JAI_CMN_RG_OTHERS JRO
500: WHERE JRO.SOURCE_REGISTER_ID in (
501: SELECT
502: RG.REGISTER_ID
503: FROM