APPS.JE_JEHUFDAN_XMLP_PKG dependencies on JE_HU_BALANCES_REPORT

Line 205: DELETE FROM JE_HU_BALANCES_REPORT;

201: AND P1.PERIOD_NAME = P_PERIOD1
202: AND P2.BOOK_TYPE_CODE = P_BOOK
203: AND P2.PERIOD_NAME = P_PERIOD2;
204: CP_BALANCE_TYPE := 'CR';
205: DELETE FROM JE_HU_BALANCES_REPORT;
206: DELETE FROM FA_LOOKUPS_B
207: WHERE LOOKUP_TYPE = 'REPORT TYPE';
208: DELETE FROM FA_LOOKUPS_TL
209: WHERE LOOKUP_TYPE = 'REPORT TYPE';

Line 254: INSERT INTO JE_HU_BALANCES_REPORT

250: END INSERT_INFO;
251:
252: PROCEDURE GET_ADJUSTMENTS IS
253: BEGIN
254: INSERT INTO JE_HU_BALANCES_REPORT
255: (CATEGORY_ID
256: ,ASSET_ID
257: ,DISTRIBUTION_CCID
258: ,ADJUSTMENT_CCID

Line 310: INSERT INTO JE_HU_BALANCES_REPORT

306: DH.CODE_COMBINATION_ID,
307: AJ.CODE_COMBINATION_ID,
308: AJ.SOURCE_TYPE_CODE;
309: IF P_REPORT_TYPE = 'RESERVE' THEN
310: INSERT INTO JE_HU_BALANCES_REPORT
311: (CATEGORY_ID
312: ,ASSET_ID
313: ,DISTRIBUTION_CCID
314: ,ADJUSTMENT_CCID

Line 335: JE_HU_BALANCES_REPORT BR

331: WHERE NOT EXISTS (
332: SELECT
333: BR.ASSET_ID
334: FROM
335: JE_HU_BALANCES_REPORT BR
336: WHERE BR.ASSET_ID = DH.ASSET_ID
337: AND BR.DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID
338: AND BR.SOURCE_TYPE_CODE = 'ADDITION' )
339: AND DD.BOOK_TYPE_CODE = P_BOOK

Line 363: INSERT INTO JE_HU_BALANCES_REPORT

359: /*SRW.MESSAGE('001'
360: ,'PC1: ' || TO_CHAR(CP_PERIOD1_PC))*/NULL;
361: /*SRW.MESSAGE('002'
362: ,'PC2: ' || TO_CHAR(CP_PERIOD2_PC))*/NULL;
363: INSERT INTO JE_HU_BALANCES_REPORT
364: (CATEGORY_ID
365: ,ASSET_ID
366: ,DISTRIBUTION_CCID
367: ,ADJUSTMENT_CCID

Line 438: INSERT INTO JE_HU_BALANCES_REPORT

434: END GET_ADJUSTMENTS_METHOD;
435:
436: PROCEDURE GET_ADJ_STR_UNPLANNED IS
437: BEGIN
438: INSERT INTO JE_HU_BALANCES_REPORT
439: (CATEGORY_ID
440: ,ASSET_ID
441: ,DISTRIBUTION_CCID
442: ,ADJUSTMENT_CCID

Line 504: INSERT INTO JE_HU_BALANCES_REPORT

500: END GET_ADJ_STR_UNPLANNED;
501:
502: PROCEDURE GET_DEPRN_EFFECTS IS
503: BEGIN
504: INSERT INTO JE_HU_BALANCES_REPORT
505: (CATEGORY_ID
506: ,ASSET_ID
507: ,DISTRIBUTION_CCID
508: ,ADJUSTMENT_CCID

Line 583: INSERT INTO JE_HU_BALANCES_REPORT

579: END GET_DEPRN_EFFECTS;
580:
581: PROCEDURE GET_DEPRN_EFFECTS_FIRST IS
582: BEGIN
583: INSERT INTO JE_HU_BALANCES_REPORT
584: (CATEGORY_ID
585: ,ASSET_ID
586: ,DISTRIBUTION_CCID
587: ,ADJUSTMENT_CCID

Line 674: INSERT INTO JE_HU_BALANCES_REPORT

670: END GET_DEPRN_EFFECTS_FIRST;
671:
672: PROCEDURE GET_DEPRN_EFFECTS_METHOD IS
673: BEGIN
674: INSERT INTO JE_HU_BALANCES_REPORT
675: (CATEGORY_ID
676: ,ASSET_ID
677: ,DISTRIBUTION_CCID
678: ,ADJUSTMENT_CCID

Line 774: INSERT INTO JE_HU_BALANCES_REPORT

770: END CF_CURRENT_DATEFORMULA;
771:
772: PROCEDURE GET_ADJ_NON_STR_UNPLANNED IS
773: BEGIN
774: INSERT INTO JE_HU_BALANCES_REPORT
775: (CATEGORY_ID
776: ,ASSET_ID
777: ,DISTRIBUTION_CCID
778: ,ADJUSTMENT_CCID

Line 850: INSERT INTO JE_HU_BALANCES_REPORT

846: END CF_UNPLANNEDFORMULA;
847:
848: PROCEDURE GET_FIRST_MON_STR_UNPL IS
849: BEGIN
850: INSERT INTO JE_HU_BALANCES_REPORT
851: (CATEGORY_ID
852: ,ASSET_ID
853: ,DISTRIBUTION_CCID
854: ,ADJUSTMENT_CCID

Line 928: INSERT INTO JE_HU_BALANCES_REPORT

924: END GET_FIRST_MON_STR_UNPL;
925:
926: PROCEDURE GET_FIRST_MON_NON_STR_UNPL IS
927: BEGIN
928: INSERT INTO JE_HU_BALANCES_REPORT
929: (CATEGORY_ID
930: ,ASSET_ID
931: ,DISTRIBUTION_CCID
932: ,ADJUSTMENT_CCID