[Home] [Help]
191: JAI_FA_AST_BLOCKS
192: WHERE TYPE = TYPE1
193: AND RATE = RATE
194: AND START_DATE < START_DATE;
195: CURSOR SALE_CUR(CP_OWNED_LEASED IN FA_ADDITIONS.OWNED_LEASED%TYPE,CP_STATUS IN FA_RETIREMENTS.STATUS%TYPE) IS
196: SELECT
197: NVL(SUM(FAR.PROCEEDS_OF_SALE - FAR.COST_OF_REMOVAL)
198: ,0) SALE
199: FROM
197: NVL(SUM(FAR.PROCEEDS_OF_SALE - FAR.COST_OF_REMOVAL)
198: ,0) SALE
199: FROM
200: JAI_FA_AST_BLOCK_DTLS JBA,
201: FA_ADDITIONS FA,
202: JAI_FA_AST_BLOCKS JABLOA,
203: FA_RETIREMENTS FAR
204: WHERE FA.OWNED_LEASED = CP_OWNED_LEASED
205: AND FA.ASSET_ID = JBA.ASSET_ID
322: NVL(SUM(C.PROCEEDS_OF_SALE - C.COST_OF_REMOVAL)
323: ,0) SALE
324: FROM
325: JAI_FA_AST_BLOCKS A,
326: FA_ADDITIONS B,
327: FA_RETIREMENTS C,
328: JAI_FA_AST_PERIOD_RATES D
329: WHERE B.CONTEXT = P_CONTEXT_VALUE
330: AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
348: NVL(SUM(C.PROCEEDS_OF_SALE - C.COST_OF_REMOVAL)
349: ,0) SALE
350: FROM
351: JAI_FA_AST_BLOCKS A,
352: FA_ADDITIONS B,
353: FA_RETIREMENTS C,
354: JAI_FA_AST_PERIOD_RATES D
355: WHERE B.CONTEXT = P_CONTEXT_VALUE
356: AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
672: JAI_FA_AST_BLOCK_DTLS A,
673: JAI_FA_AST_BLOCKS B,
674: JAI_FA_AST_PERIOD_RATES C,
675: FA_BOOKS D,
676: FA_ADDITIONS E
677: WHERE E.OWNED_LEASED = LV_OWNED
678: AND E.ASSET_ID = A.ASSET_ID
679: AND NVL(A.ASSET_ID
680: ,0) = NVL(D.ASSET_ID
701: JAI_FA_AST_BLOCK_DTLS A,
702: JAI_FA_AST_BLOCKS B,
703: JAI_FA_AST_PERIOD_RATES C,
704: FA_BOOKS D,
705: FA_ADDITIONS E
706: WHERE E.OWNED_LEASED = 'OWNED'
707: AND E.ASSET_ID = A.ASSET_ID
708: AND NVL(A.ASSET_ID
709: ,0) = NVL(D.ASSET_ID
791: A.DATE_PLACED_IN_SERVICE
792: FROM
793: FA_BOOKS A,
794: JAI_FA_AST_BLOCK_DTLS B,
795: FA_ADDITIONS C
796: WHERE A.ASSET_ID = P_ASSET_ID
797: AND A.ASSET_ID = B.ASSET_ID
798: AND A.DATE_INEFFECTIVE is null
799: AND A.TRANSACTION_HEADER_ID_OUT is null
817: A.DATE_PLACED_IN_SERVICE
818: FROM
819: FA_BOOKS A,
820: JAI_FA_AST_BLOCK_DTLS B,
821: FA_ADDITIONS C
822: WHERE A.ASSET_ID = P_ASSET_ID
823: AND A.ASSET_ID = B.ASSET_ID
824: AND A.ASSET_ID = B.ASSET_ID
825: AND A.DATE_INEFFECTIVE is null
1170: ,P_BOOK_NAME IN VARCHAR2) IS
1171: LV_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
1172: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
1173: LV_EXPENSED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
1174: LV_OWNED_LEASED FA_ADDITIONS.OWNED_LEASED%TYPE;
1175: LV_STATUS FA_RETIREMENTS.STATUS%TYPE;
1176: V_C NUMBER := 0;
1177: K NUMBER := 0;
1178: I NUMBER := 0;
1255: ,B.START_DATE) AQUISATION_DATE,
1256: D.DATE_PLACED_IN_SERVICE,
1257: A.CURRENT_UNITS
1258: FROM
1259: FA_ADDITIONS A,
1260: JAI_FA_AST_BLOCKS B,
1261: JAI_FA_AST_PERIOD_RATES C,
1262: FA_BOOKS D,
1263: JAI_FA_AST_BLOCK_DTLS E
1373: A.ASSET_ID,
1374: A.DATE_PLACED_IN_SERVICE
1375: FROM
1376: FA_BOOKS A,
1377: FA_ADDITIONS B,
1378: JAI_FA_AST_BLOCK_DTLS C
1379: WHERE A.ASSET_ID = P_ASSET_ID
1380: AND A.ASSET_ID = C.ASSET_ID
1381: AND ( ( B.ASSET_TYPE = LV_CAPITALIZED
1395: A.ASSET_ID,
1396: A.DATE_PLACED_IN_SERVICE
1397: FROM
1398: FA_BOOKS A,
1399: FA_ADDITIONS B,
1400: JAI_FA_AST_BLOCK_DTLS C
1401: WHERE A.ASSET_ID = P_ASSET_ID
1402: AND A.ASSET_ID = C.ASSET_ID
1403: AND ( ( B.ASSET_TYPE = LV_CAPITALIZED
1479: CURSOR COUNT_CUR(P_BLOCK_ID IN NUMBER) IS
1480: SELECT
1481: count(*)
1482: FROM
1483: FA_ADDITIONS A,
1484: JAI_FA_AST_BLOCKS B,
1485: JAI_FA_AST_PERIOD_RATES C,
1486: FA_BOOKS D,
1487: JAI_FA_AST_BLOCK_DTLS E
1653: INTO V_ASSET_ID,V_BLOCK_ID,V_OPENING_WDV,V_BLOCK_RATE,V_SLNO,V_START_DATE,V_END_DATE,V_PERIOD_RATE,V_EXEMPT_UPTO,V_AQUISATION_DATE,V_DATE_PLACED_IN_SERVICE,V_CURRENT_UNITS;
1654: NULL;
1655: IF ASSET_BLOCK_CUR%NOTFOUND THEN
1656: /*SRW.MESSAGE(1006
1657: ,'2.1B No assets found in fa_additions_b')*/NULL;
1658: FOR block_id IN BLOCK_ID_CUR LOOP
1659: NULL;
1660: FOR closing IN CLOSING_BALANCE_CUR(block_id.block_id) LOOP
1661: NULL;
3992: NVL(SUM(C.PROCEEDS_OF_SALE - C.COST_OF_REMOVAL)
3993: ,0) SALE
3994: FROM
3995: JAI_FA_AST_BLOCKS A,
3996: FA_ADDITIONS B,
3997: FA_RETIREMENTS C,
3998: JAI_FA_AST_PERIOD_RATES D
3999: WHERE B.CONTEXT = P_CONTEXT_VALUE
4000: AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
4018: NVL(SUM(C.PROCEEDS_OF_SALE - C.COST_OF_REMOVAL)
4019: ,0) SALE
4020: FROM
4021: JAI_FA_AST_BLOCKS A,
4022: FA_ADDITIONS B,
4023: FA_RETIREMENTS C,
4024: JAI_FA_AST_PERIOD_RATES D
4025: WHERE B.CONTEXT = P_CONTEXT_VALUE
4026: AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
4177: CURSOR GET_NULL_ATTR1 IS
4178: SELECT
4179: COUNT(*)
4180: FROM
4181: FA_ADDITIONS
4182: WHERE LENGTH(ATTRIBUTE1) = 1
4183: AND CONTEXT = P_CONTEXT_VALUE;
4184: V_COUNT NUMBER;
4185: CURSOR GET_VAL_ATTR1 IS
4185: CURSOR GET_VAL_ATTR1 IS
4186: SELECT
4187: count(*)
4188: FROM
4189: FA_ADDITIONS
4190: WHERE ATTRIBUTE1 IS NOT NULL
4191: AND LENGTH(ATTRIBUTE1) <> 0
4192: AND CONTEXT = P_CONTEXT_VALUE;
4193: V_COUNT_ATTR NUMBER;
4201: INTO V_COUNT_ATTR;
4202: CLOSE GET_VAL_ATTR1;
4203: IF V_COUNT > 0 THEN
4204: UPDATE
4205: FA_ADDITIONS_B
4206: SET
4207: ATTRIBUTE1 = NULL
4208: WHERE LENGTH(ATTRIBUTE1) = 1
4209: AND CONTEXT = P_CONTEXT_VALUE;
4210: COMMIT;
4211: END IF;
4212: IF V_COUNT_ATTR > 0 THEN
4213: UPDATE
4214: FA_ADDITIONS_B
4215: SET
4216: ATTRIBUTE1 = TO_CHAR(TO_DATE(ATTRIBUTE1
4217: ,'DD-MON-RRRR')
4218: ,'DD-MON-RRRR')
4235: CURSOR GET_ATTR_CONTEXT IS
4236: SELECT
4237: CONTEXT
4238: FROM
4239: FA_ADDITIONS_B
4240: WHERE ATTRIBUTE1 is NOT NULL
4241: AND ATTRIBUTE2 IN (
4242: SELECT
4243: DISTINCT
4250: FETCH GET_ATTR_CONTEXT
4251: INTO GET_ATTR_CONTEXT_REC;
4252: IF GET_ATTR_CONTEXT%FOUND THEN
4253: UPDATE
4254: FA_ADDITIONS_B
4255: SET
4256: CONTEXT = 'India B Of Assets'
4257: WHERE ATTRIBUTE1 IS NOT NULL
4258: AND ATTRIBUTE2 IN (