APPS.JA_JAINYEDE_XMLP_PKG dependencies on FA_ADDITIONS_B

Line 326: FA_ADDITIONS B,

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

Line 352: FA_ADDITIONS B,

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

Line 1377: FA_ADDITIONS B,

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

Line 1399: FA_ADDITIONS B,

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

Line 1657: ,'2.1B No assets found in fa_additions_b')*/NULL;

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;

Line 3996: FA_ADDITIONS B,

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

Line 4022: FA_ADDITIONS B,

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

Line 4205: FA_ADDITIONS_B

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;

Line 4214: FA_ADDITIONS_B

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')

Line 4239: FA_ADDITIONS_B

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

Line 4254: FA_ADDITIONS_B

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 (