eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JE_JEHUFDAN_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 55: FA_DEPRN_PERIODS

51: ,'OPEN'
52: ,'CLOSED')
53: INTO CP_OPEN_CLOSED
54: FROM
55: FA_DEPRN_PERIODS
56: WHERE BOOK_TYPE_CODE = P_BOOK
57: AND PERIOD_NAME = P_PERIOD2;
58: RETURN (TRUE);
59: END BEFOREREPORT;

Line 89: FA_DEPRN_PERIODS

85: ,SYSDATE),
86: FISCAL_YEAR
87: INTO L_PERIOD_PC,L_PERIOD_POD,L_PERIOD_PCD,L_PERIOD_FY
88: FROM
89: FA_DEPRN_PERIODS
90: WHERE BOOK_TYPE_CODE = P_BOOK
91: AND PERIOD_NAME = P_PERIOD1;
92: PERIOD1_POD := L_PERIOD_POD;
93: PERIOD1_PCD := L_PERIOD_PCD;

Line 116: FA_DEPRN_PERIODS

112: ,SYSDATE),
113: FISCAL_YEAR
114: INTO L_PERIOD_PC,L_PERIOD_POD,L_PERIOD_PCD,L_PERIOD_FY
115: FROM
116: FA_DEPRN_PERIODS
117: WHERE BOOK_TYPE_CODE = P_BOOK
118: AND PERIOD_NAME = P_PERIOD2;
119: PERIOD2_POD := L_PERIOD_POD;
120: PERIOD2_PCD := L_PERIOD_PCD;

Line 196: FA_DEPRN_PERIODS P1,

192: ,SYSDATE),
193: BC.DISTRIBUTION_SOURCE_BOOK
194: INTO CP_PERIOD1_PC,CP_PERIOD1_POD,CP_PERIOD1_PCD,CP_PERIOD2_PC,CP_PERIOD2_PCD,CP_DISTRIBUTION_SOURCE_BOOK
195: FROM
196: FA_DEPRN_PERIODS P1,
197: FA_DEPRN_PERIODS P2,
198: FA_BOOK_CONTROLS BC
199: WHERE BC.BOOK_TYPE_CODE = P_BOOK
200: AND P1.BOOK_TYPE_CODE = P_BOOK

Line 197: FA_DEPRN_PERIODS P2,

193: BC.DISTRIBUTION_SOURCE_BOOK
194: INTO CP_PERIOD1_PC,CP_PERIOD1_POD,CP_PERIOD1_PCD,CP_PERIOD2_PC,CP_PERIOD2_PCD,CP_DISTRIBUTION_SOURCE_BOOK
195: FROM
196: FA_DEPRN_PERIODS P1,
197: FA_DEPRN_PERIODS P2,
198: FA_BOOK_CONTROLS BC
199: WHERE BC.BOOK_TYPE_CODE = P_BOOK
200: AND P1.BOOK_TYPE_CODE = P_BOOK
201: AND P1.PERIOD_NAME = P_PERIOD1

Line 390: FA_DEPRN_PERIODS DP

386: FA_ASSET_HISTORY AH,
387: FA_ADJUSTMENTS AJ,
388: FA_METHODS ME,
389: FA_BOOKS BO,
390: FA_DEPRN_PERIODS DP
391: WHERE RT.LOOKUP_TYPE = 'REPORT TYPE'
392: AND RT.LOOKUP_CODE = P_REPORT_TYPE
393: AND DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK
394: AND AJ.ASSET_ID = DH.ASSET_ID

Line 537: FA_DEPRN_PERIODS DP

533: FA_CATEGORY_BOOKS CB,
534: FA_DISTRIBUTION_HISTORY DH,
535: FA_ASSET_HISTORY AH,
536: FA_DEPRN_DETAIL DD,
537: FA_DEPRN_PERIODS DP
538: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK
539: AND AH.ASSET_ID = DH.ASSET_ID
540: AND AH.ASSET_TYPE = 'CAPITALIZED'
541: AND AH.DATE_EFFECTIVE < NVL(DH.DATE_INEFFECTIVE

Line 613: FA_DEPRN_PERIODS DP,

609: FA_CATEGORY_BOOKS CB,
610: FA_DISTRIBUTION_HISTORY DH,
611: FA_ASSET_HISTORY AH,
612: FA_DEPRN_DETAIL DD,
613: FA_DEPRN_PERIODS DP,
614: FA_DEPRN_PERIODS DP1,
615: FA_BOOKS BO
616: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK
617: AND AH.ASSET_ID = DH.ASSET_ID

Line 614: FA_DEPRN_PERIODS DP1,

610: FA_DISTRIBUTION_HISTORY DH,
611: FA_ASSET_HISTORY AH,
612: FA_DEPRN_DETAIL DD,
613: FA_DEPRN_PERIODS DP,
614: FA_DEPRN_PERIODS DP1,
615: FA_BOOKS BO
616: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK
617: AND AH.ASSET_ID = DH.ASSET_ID
618: AND AH.ASSET_TYPE = 'CAPITALIZED'

Line 704: FA_DEPRN_PERIODS DP,

700: FA_CATEGORY_BOOKS CB,
701: FA_DISTRIBUTION_HISTORY DH,
702: FA_ASSET_HISTORY AH,
703: FA_DEPRN_DETAIL DD,
704: FA_DEPRN_PERIODS DP,
705: FA_DEPRN_PERIODS DP1,
706: FA_METHODS ME,
707: FA_BOOKS BO
708: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK

Line 705: FA_DEPRN_PERIODS DP1,

701: FA_DISTRIBUTION_HISTORY DH,
702: FA_ASSET_HISTORY AH,
703: FA_DEPRN_DETAIL DD,
704: FA_DEPRN_PERIODS DP,
705: FA_DEPRN_PERIODS DP1,
706: FA_METHODS ME,
707: FA_BOOKS BO
708: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK
709: AND AH.ASSET_ID = DH.ASSET_ID

Line 877: FA_DEPRN_PERIODS DP,

873: FA_CATEGORY_BOOKS CB,
874: FA_DISTRIBUTION_HISTORY DH,
875: FA_ASSET_HISTORY AH,
876: FA_DEPRN_DETAIL DD,
877: FA_DEPRN_PERIODS DP,
878: FA_BOOKS BO,
879: FA_METHODS ME,
880: FA_TRANSACTION_HEADERS TH
881: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK

Line 955: FA_DEPRN_PERIODS DP,

951: FA_CATEGORY_BOOKS CB,
952: FA_DISTRIBUTION_HISTORY DH,
953: FA_ASSET_HISTORY AH,
954: FA_DEPRN_DETAIL DD,
955: FA_DEPRN_PERIODS DP,
956: FA_BOOKS BO,
957: FA_METHODS ME,
958: FA_TRANSACTION_HEADERS TH
959: WHERE DH.BOOK_TYPE_CODE = CP_DISTRIBUTION_SOURCE_BOOK

Line 1134: FROM FA_DEPRN_PERIODS

1130: BEGIN
1131:
1132: SELECT PERIOD_CLOSE_DATE
1133: INTO END_DATE
1134: FROM FA_DEPRN_PERIODS
1135: WHERE BOOK_TYPE_CODE = P_BOOK
1136: AND PERIOD_NAME = P_PERIOD2;
1137:
1138: