APPS.JA_JAINASST_XMLP_PKG dependencies on FA_ADDITIONS

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 60: FA_ADDITIONS FA,

56: NVL(SUM(FAR.PROCEEDS_OF_SALE - FAR.COST_OF_REMOVAL)
57: ,0) SALE
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

Line 203: FA_ADDITIONS B,

199: NVL(SUM(C.PROCEEDS_OF_SALE - C.COST_OF_REMOVAL)
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

Line 229: FA_ADDITIONS B,

225: NVL(SUM(C.PROCEEDS_OF_SALE - C.COST_OF_REMOVAL)
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