APPS.JA_JAINASST_XMLP_PKG dependencies on JAI_FA_AST_BLOCK_DTLS

Line 59: JAI_FA_AST_BLOCK_DTLS JBA,

55: SELECT
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

Line 117: LV_ASSEST_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;

113: ,TYPE IN VARCHAR2
114: ,OP_TOT IN NUMBER
115: ,COS_TOT IN NUMBER
116: ,RATE IN NUMBER) RETURN NUMBER IS
117: LV_ASSEST_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
118: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
119: LV_ASSET_TYPE JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
120: CURSOR CUR_GET_VALID_ASSETS IS
121: SELECT

Line 119: LV_ASSET_TYPE JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;

115: ,COS_TOT IN NUMBER
116: ,RATE IN NUMBER) RETURN NUMBER IS
117: LV_ASSEST_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
118: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
119: LV_ASSET_TYPE JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
120: CURSOR CUR_GET_VALID_ASSETS IS
121: SELECT
122: '1'
123: FROM

Line 124: JAI_FA_AST_BLOCK_DTLS JBA,

120: CURSOR CUR_GET_VALID_ASSETS IS
121: SELECT
122: '1'
123: FROM
124: JAI_FA_AST_BLOCK_DTLS JBA,
125: FA_BOOKS FAB,
126: JAI_FA_AST_BLOCKS JABOA
127: WHERE JBA.ASSET_ID = FAB.ASSET_ID
128: AND ( ( JBA.ASSET_TYPE = LV_ASSEST_CAPITALIZED

Line 177: JAI_FA_AST_BLOCK_DTLS C,

173: A.DATE_EFFECTIVE
174: FROM
175: FA_BOOKS A,
176: JAI_FA_AST_BLOCKS B,
177: JAI_FA_AST_BLOCK_DTLS C,
178: JAI_FA_AST_PERIOD_RATES D
179: WHERE A.ASSET_ID = C.ASSET_ID
180: AND ( ( C.ASSET_TYPE = LV_ASSEST_CAPITALIZED
181: AND A.CAPITALIZE_FLAG = LV_FLAG )

Line 338: LV_ASSEST_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;

334: RETURN (TRUE);
335: END AFTERREPORT;
336:
337: FUNCTION CF_8FORMULA(BLOCK_ID IN NUMBER) RETURN NUMBER IS
338: LV_ASSEST_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
339: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
340: LV_ASSET_TYPE JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
341: CURSOR ASSET_COST IS
342: SELECT

Line 340: LV_ASSET_TYPE JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;

336:
337: FUNCTION CF_8FORMULA(BLOCK_ID IN NUMBER) RETURN NUMBER IS
338: LV_ASSEST_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
339: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
340: LV_ASSET_TYPE JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
341: CURSOR ASSET_COST IS
342: SELECT
343: NVL(SUM(COST)
344: ,0) COST

Line 347: JAI_FA_AST_BLOCK_DTLS B

343: NVL(SUM(COST)
344: ,0) COST
345: FROM
346: FA_BOOKS A,
347: JAI_FA_AST_BLOCK_DTLS B
348: WHERE A.ASSET_ID NOT IN (
349: SELECT
350: ASSET_ID
351: FROM