APPS.JA_JAINER1_XMLP_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 113: JAI_CMN_RG_PLA_TRXS

109: SUM(NVL(CR_BASIC_ED
110: ,0) + NVL(CR_OTHER_ED
111: ,0))
112: FROM
113: JAI_CMN_RG_PLA_TRXS
114: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
115: AND LOCATION_ID = P_LOCATION_ID
116: AND CREATION_DATE >= P_START_DATE
117: AND CREATION_DATE <= TRUNC(NVL(P_END_DATE

Line 149: JAI_CMN_RG_PLA_TRXS

145: AND SOURCE_REGISTER_ID in (
146: SELECT
147: REGISTER_ID
148: FROM
149: JAI_CMN_RG_PLA_TRXS
150: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
151: AND LOCATION_ID = P_LOCATION_ID
152: AND CREATION_DATE >= P_START_DATE
153: AND CREATION_DATE <= TRUNC(NVL(P_END_DATE

Line 763: JAI_CMN_RG_PLA_TRXS

759: NVL(SUM(CR_BASIC_ED)
760: ,0)
761: INTO LN_TAX_DUTY_SRVCS
762: FROM
763: JAI_CMN_RG_PLA_TRXS
764: WHERE TRANSACTION_SOURCE_NUM = 151
765: AND ORGANIZATION_ID = P_ORGANIZATION_ID
766: AND LOCATION_ID = P_LOCATION_ID
767: AND CREATION_DATE >= P_START_DATE

Line 787: JAI_CMN_RG_PLA_TRXS

783: NVL(SUM(OTHER_TAX_CREDIT)
784: ,0)
785: INTO LN_CESS_TAX_DUTY_SRVCS
786: FROM
787: JAI_CMN_RG_PLA_TRXS
788: WHERE TRANSACTION_SOURCE_NUM = 151
789: AND ORGANIZATION_ID = P_ORGANIZATION_ID
790: AND LOCATION_ID = P_LOCATION_ID
791: AND TRUNC(CREATION_DATE) >= P_START_DATE

Line 2477: LN_OPENING_BALANCE JAI_CMN_RG_PLA_TRXS.OPENING_BALANCE%TYPE;

2473: ,0);
2474: END CF_CRDT_AVALIED_CAP_GOODSFORMU;
2475:
2476: FUNCTION CF_PLA_OPENING_BALANCEFORMULA RETURN NUMBER IS
2477: LN_OPENING_BALANCE JAI_CMN_RG_PLA_TRXS.OPENING_BALANCE%TYPE;
2478: BEGIN
2479: SELECT
2480: SUM(NVL(CR_BASIC_ED
2481: ,0) + NVL(CR_ADDITIONAL_ED

Line 2489: JAI_CMN_RG_PLA_TRXS

2485: ,0) - NVL(DR_OTHER_ED
2486: ,0))
2487: INTO LN_OPENING_BALANCE
2488: FROM
2489: JAI_CMN_RG_PLA_TRXS
2490: WHERE LOCATION_ID = P_LOCATION_ID
2491: AND ORGANIZATION_ID = P_ORGANIZATION_ID
2492: AND CREATION_DATE < P_START_DATE;
2493: RETURN ROUND(NVL(LN_OPENING_BALANCE

Line 2563: JAI_CMN_RG_PLA_TRXS

2559: ROUND(SUM(NVL(CR_ADDITIONAL_ED
2560: ,0))
2561: ,0)
2562: FROM
2563: JAI_CMN_RG_PLA_TRXS
2564: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
2565: AND LOCATION_ID = P_LOCATION_ID
2566: AND CREATION_DATE >= P_START_DATE
2567: AND CREATION_DATE <= TRUNC(NVL(P_END_DATE

Line 3351: JAI_CMN_RG_PLA_TRXS

3347: AND SOURCE_REGISTER_ID in (
3348: SELECT
3349: REGISTER_ID
3350: FROM
3351: JAI_CMN_RG_PLA_TRXS
3352: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
3353: AND LOCATION_ID = P_LOCATION_ID
3354: AND CREATION_DATE >= P_START_DATE
3355: AND CREATION_DATE <= TRUNC(NVL(P_END_DATE