APPS.JE_JEHUFAMD_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 50: FA_DEPRN_PERIODS

46: SELECT
47: PERIOD_CLOSE_DATE
48: INTO CP_END_DATE
49: FROM
50: FA_DEPRN_PERIODS
51: WHERE BOOK_TYPE_CODE = P_BOOK
52: AND PERIOD_NAME = P_PERIOD2;
53: IF CP_END_DATE IS NULL THEN
54: CP_END_DATE_OPEN := 'YES';

Line 77: FA_DEPRN_PERIODS

73: ,SYSDATE),
74: FISCAL_YEAR
75: INTO L_PERIOD_PC,L_PERIOD_POD,L_PERIOD_PCD,L_PERIOD_FY
76: FROM
77: FA_DEPRN_PERIODS
78: WHERE BOOK_TYPE_CODE = P_BOOK
79: AND PERIOD_NAME = P_PERIOD1;
80: PERIOD1_POD := L_PERIOD_POD;
81: PERIOD1_PCD := L_PERIOD_PCD;

Line 104: FA_DEPRN_PERIODS

100: ,SYSDATE),
101: FISCAL_YEAR
102: INTO L_PERIOD_PC,L_PERIOD_POD,L_PERIOD_PCD,L_PERIOD_FY
103: FROM
104: FA_DEPRN_PERIODS
105: WHERE BOOK_TYPE_CODE = P_BOOK
106: AND PERIOD_NAME = P_PERIOD2;
107: PERIOD2_POD := L_PERIOD_POD;
108: PERIOD2_PCD := L_PERIOD_PCD;

Line 405: FA_DEPRN_PERIODS DP

401: FA_CATEGORY_BOOKS CB,
402: FA_DISTRIBUTION_HISTORY DH,
403: FA_ASSET_HISTORY AH,
404: FA_DEPRN_DETAIL DD,
405: FA_DEPRN_PERIODS DP
406: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK
407: AND AH.ASSET_ID = DH.ASSET_ID
408: AND AH.ASSET_TYPE = 'CAPITALIZED'
409: AND AH.DATE_EFFECTIVE < NVL(DH.DATE_INEFFECTIVE

Line 469: FA_DEPRN_PERIODS P1,

465: ,BC.LAST_DEPRN_RUN_DATE),
466: BC.DISTRIBUTION_SOURCE_BOOK
467: INTO CP_PERIOD1_PC,CP_PERIOD1_POD,CP_PERIOD1_PCD,CP_PERIOD2_PC,CP_PERIOD2_PCD,CP_DISTRIBUTION_SOURCE_BOOK
468: FROM
469: FA_DEPRN_PERIODS P1,
470: FA_DEPRN_PERIODS P2,
471: FA_BOOK_CONTROLS BC
472: WHERE BC.BOOK_TYPE_CODE = P_BOOK
473: AND P1.BOOK_TYPE_CODE = P_BOOK

Line 470: FA_DEPRN_PERIODS P2,

466: BC.DISTRIBUTION_SOURCE_BOOK
467: INTO CP_PERIOD1_PC,CP_PERIOD1_POD,CP_PERIOD1_PCD,CP_PERIOD2_PC,CP_PERIOD2_PCD,CP_DISTRIBUTION_SOURCE_BOOK
468: FROM
469: FA_DEPRN_PERIODS P1,
470: FA_DEPRN_PERIODS P2,
471: FA_BOOK_CONTROLS BC
472: WHERE BC.BOOK_TYPE_CODE = P_BOOK
473: AND P1.BOOK_TYPE_CODE = P_BOOK
474: AND P1.PERIOD_NAME = P_PERIOD1