APPS.JA_JAINYEDE_XMLP_PKG dependencies on JAI_FA_AST_YEARS

Line 80: JAI_FA_AST_YEARS

76: CURSOR YEAR_END_CUR IS
77: SELECT
78: YEAR_END
79: FROM
80: JAI_FA_AST_YEARS
81: WHERE YEAR_START = START_DATE;
82: BEGIN
83: OPEN YEAR_END_CUR;
84: FETCH YEAR_END_CUR

Line 1015: JAI_FA_AST_YEARS

1011: CURSOR YEAR_END_CUR(P_START_DATE IN DATE) IS
1012: SELECT
1013: YEAR_END
1014: FROM
1015: JAI_FA_AST_YEARS
1016: WHERE YEAR_START = P_START_DATE;
1017: CURSOR COUNT_DEPN_CUR(P_BLOCK_ID IN NUMBER,P_SLNO IN NUMBER,P_ASSET_ID IN NUMBER) IS
1018: SELECT
1019: count(*)

Line 1590: JAI_FA_AST_YEARS

1586: CURSOR YEAR_END_CUR(P_START_DATE IN DATE) IS
1587: SELECT
1588: YEAR_END
1589: FROM
1590: JAI_FA_AST_YEARS
1591: WHERE YEAR_START = P_START_DATE;
1592: CURSOR COUNT_DEPN_CUR(P_BLOCK_ID IN NUMBER,P_SLNO IN NUMBER,P_ASSET_ID IN NUMBER) IS
1593: SELECT
1594: COUNT(*)

Line 3021: JAI_FA_AST_YEARS

3017: CURSOR YEAR_END_CUR(P_START_DATE IN DATE) IS
3018: SELECT
3019: YEAR_END
3020: FROM
3021: JAI_FA_AST_YEARS
3022: WHERE YEAR_START = P_START_DATE;
3023: CURSOR COUNT_DEPN_CUR(P_BLOCK_ID IN NUMBER,P_SLNO IN NUMBER,P_ASSET_ID IN NUMBER) IS
3024: SELECT
3025: count(*)

Line 3896: ,P_YEAR_START IN JAI_FA_AST_YEARS.YEAR_START%TYPE

3892: RETURN (V_ASSET_COST);
3893: END CF_9FORMULA;
3894:
3895: FUNCTION TOTALDEPRN(P_BOOK_NAME IN JAI_FA_AST_BLOCKS.BOOK_TYPE_CODE%TYPE
3896: ,P_YEAR_START IN JAI_FA_AST_YEARS.YEAR_START%TYPE
3897: ,P_YEAR_END IN JAI_FA_AST_YEARS.YEAR_END%TYPE
3898: ,P_BLOCK_ID IN JAI_FA_AST_BLOCKS.BLOCK_ID%TYPE
3899: ,P_NO_ASSETS OUT NOCOPY VARCHAR2) RETURN NUMBER IS
3900: LV_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;

Line 3897: ,P_YEAR_END IN JAI_FA_AST_YEARS.YEAR_END%TYPE

3893: END CF_9FORMULA;
3894:
3895: FUNCTION TOTALDEPRN(P_BOOK_NAME IN JAI_FA_AST_BLOCKS.BOOK_TYPE_CODE%TYPE
3896: ,P_YEAR_START IN JAI_FA_AST_YEARS.YEAR_START%TYPE
3897: ,P_YEAR_END IN JAI_FA_AST_YEARS.YEAR_END%TYPE
3898: ,P_BLOCK_ID IN JAI_FA_AST_BLOCKS.BLOCK_ID%TYPE
3899: ,P_NO_ASSETS OUT NOCOPY VARCHAR2) RETURN NUMBER IS
3900: LV_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
3901: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;