APPS.JE_JEHUFAMS_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 44: FA_DEPRN_PERIODS

40: SELECT
41: PERIOD_CLOSE_DATE
42: INTO CP_END_DATE
43: FROM
44: FA_DEPRN_PERIODS
45: WHERE BOOK_TYPE_CODE = P_BOOK
46: AND PERIOD_NAME = P_PERIOD2;
47: IF CP_END_DATE IS NULL THEN
48: CP_END_PERIOD_OPEN := 'YES';

Line 85: FA_DEPRN_PERIODS

81: ,SYSDATE),
82: FISCAL_YEAR
83: INTO L_PERIOD_PC,L_PERIOD_POD,L_PERIOD_PCD,L_PERIOD_FY
84: FROM
85: FA_DEPRN_PERIODS
86: WHERE BOOK_TYPE_CODE = P_BOOK
87: AND PERIOD_NAME = P_PERIOD1;
88: PERIOD1_POD := L_PERIOD_POD;
89: PERIOD1_PCD := L_PERIOD_PCD;

Line 112: FA_DEPRN_PERIODS

108: ,SYSDATE),
109: FISCAL_YEAR
110: INTO L_PERIOD_PC,L_PERIOD_POD,L_PERIOD_PCD,L_PERIOD_FY
111: FROM
112: FA_DEPRN_PERIODS
113: WHERE BOOK_TYPE_CODE = P_BOOK
114: AND PERIOD_NAME = P_PERIOD2;
115: PERIOD2_POD := L_PERIOD_POD;
116: 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 463: FA_DEPRN_PERIODS P1,

459: ,BC.LAST_DEPRN_RUN_DATE),
460: BC.DISTRIBUTION_SOURCE_BOOK
461: INTO CP_PERIOD1_PC,CP_PERIOD1_POD,CP_PERIOD1_PCD,CP_PERIOD2_PC,CP_PERIOD2_PCD,CP_DISTRIBUTION_SOURCE_BOOK
462: FROM
463: FA_DEPRN_PERIODS P1,
464: FA_DEPRN_PERIODS P2,
465: FA_BOOK_CONTROLS BC
466: WHERE BC.BOOK_TYPE_CODE = P_BOOK
467: AND P1.BOOK_TYPE_CODE = P_BOOK

Line 464: FA_DEPRN_PERIODS P2,

460: BC.DISTRIBUTION_SOURCE_BOOK
461: INTO CP_PERIOD1_PC,CP_PERIOD1_POD,CP_PERIOD1_PCD,CP_PERIOD2_PC,CP_PERIOD2_PCD,CP_DISTRIBUTION_SOURCE_BOOK
462: FROM
463: FA_DEPRN_PERIODS P1,
464: FA_DEPRN_PERIODS P2,
465: FA_BOOK_CONTROLS BC
466: WHERE BC.BOOK_TYPE_CODE = P_BOOK
467: AND P1.BOOK_TYPE_CODE = P_BOOK
468: AND P1.PERIOD_NAME = P_PERIOD1