APPS.JA_JAINASST_XMLP_PKG dependencies on FA_RETIREMENTS

Line 54: CURSOR SALE_CUR(CP_OWNED_LEASED IN FA_ADDITIONS.OWNED_LEASED%TYPE,CP_STATUS IN FA_RETIREMENTS.STATUS%TYPE) IS

50: WHERE TYPE = CF_4FORMULA.TYPE
51: AND RATE = CF_4FORMULA.RATE
52: AND START_DATE < JA_JAINASST_XMLP_PKG.START_DATE
53: AND BOOK_TYPE_CODE = BOOK_NAME;
54: CURSOR SALE_CUR(CP_OWNED_LEASED IN FA_ADDITIONS.OWNED_LEASED%TYPE,CP_STATUS IN FA_RETIREMENTS.STATUS%TYPE) IS
55: SELECT
56: NVL(SUM(FAR.PROCEEDS_OF_SALE - FAR.COST_OF_REMOVAL)
57: ,0) SALE
58: FROM

Line 62: FA_RETIREMENTS FAR

58: FROM
59: JAI_FA_AST_BLOCK_DTLS JBA,
60: FA_ADDITIONS FA,
61: JAI_FA_AST_BLOCKS JABLOA,
62: FA_RETIREMENTS FAR
63: WHERE FA.OWNED_LEASED = CP_OWNED_LEASED
64: AND FA.ASSET_ID = JBA.ASSET_ID
65: AND JBA.BLOCK_ID = JABLOA.BLOCK_ID
66: AND FAR.BOOK_TYPE_CODE = JABLOA.BOOK_TYPE_CODE

Line 204: FA_RETIREMENTS C,

200: ,0) SALE
201: FROM
202: JAI_FA_AST_BLOCKS A,
203: FA_ADDITIONS B,
204: FA_RETIREMENTS C,
205: JAI_FA_AST_PERIOD_RATES D
206: WHERE B.CONTEXT = P_CONTEXT_VALUE
207: AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
208: AND A.BOOK_TYPE_CODE = BOOK_NAME

Line 230: FA_RETIREMENTS C,

226: ,0) SALE
227: FROM
228: JAI_FA_AST_BLOCKS A,
229: FA_ADDITIONS B,
230: FA_RETIREMENTS C,
231: JAI_FA_AST_PERIOD_RATES D
232: WHERE B.CONTEXT = P_CONTEXT_VALUE
233: AND TO_CHAR(A.BLOCK_ID) = B.ATTRIBUTE2
234: AND A.BOOK_TYPE_CODE = BOOK_NAME

Line 352: FA_RETIREMENTS

348: WHERE A.ASSET_ID NOT IN (
349: SELECT
350: ASSET_ID
351: FROM
352: FA_RETIREMENTS
353: WHERE BOOK_TYPE_CODE = BOOK_NAME
354: AND STATUS = 'PROCESSED'
355: AND DATE_RETIRED between START_DATE
356: AND END_DATE )