APPS.JE_JEHUFAMS_XMLP_PKG dependencies on JE_HU_BALANCES_REPORT

Line 250: INSERT INTO JE_HU_BALANCES_REPORT

246: END CF_REPORT_DATEFORMULA;
247:
248: PROCEDURE GET_ADJUSTMENTS IS
249: BEGIN
250: INSERT INTO JE_HU_BALANCES_REPORT
251: (CATEGORY_ID
252: ,ASSET_ID
253: ,DISTRIBUTION_CCID
254: ,ADJUSTMENT_CCID

Line 323: INSERT INTO JE_HU_BALANCES_REPORT

319: DH.CODE_COMBINATION_ID,
320: XAL.CODE_COMBINATION_ID,
321: AJ.SOURCE_TYPE_CODE;
322: IF P_REPORT_TYPE = 'RESERVE' THEN
323: INSERT INTO JE_HU_BALANCES_REPORT
324: (CATEGORY_ID
325: ,ASSET_ID
326: ,DISTRIBUTION_CCID
327: ,ADJUSTMENT_CCID

Line 348: JE_HU_BALANCES_REPORT BR

344: WHERE NOT EXISTS (
345: SELECT
346: BR.ASSET_ID
347: FROM
348: JE_HU_BALANCES_REPORT BR
349: WHERE BR.ASSET_ID = DH.ASSET_ID
350: AND BR.DISTRIBUTION_CCID = DH.CODE_COMBINATION_ID
351: AND BR.SOURCE_TYPE_CODE = 'ADDITION' )
352: AND DD.BOOK_TYPE_CODE = P_BOOK

Line 372: INSERT INTO JE_HU_BALANCES_REPORT

368: END GET_ADJUSTMENTS;
369:
370: PROCEDURE GET_DEPRN_EFFECTS IS
371: BEGIN
372: INSERT INTO JE_HU_BALANCES_REPORT
373: (CATEGORY_ID
374: ,ASSET_ID
375: ,DISTRIBUTION_CCID
376: ,ADJUSTMENT_CCID

Line 476: DELETE FROM JE_HU_BALANCES_REPORT;

472: CP_BALANCE_TYPE := 'CR';
473: ELSE
474: CP_BALANCE_TYPE := 'DR';
475: END IF;
476: DELETE FROM JE_HU_BALANCES_REPORT;
477: DELETE FROM FA_LOOKUPS_B
478: WHERE LOOKUP_TYPE = 'REPORT TYPE';
479: DELETE FROM FA_LOOKUPS_TL
480: WHERE LOOKUP_TYPE = 'REPORT TYPE';

Line 544: INSERT INTO JE_HU_BALANCES_REPORT

540: END INSERT_INFO;
541:
542: PROCEDURE GET_BALANCE IS
543: BEGIN
544: INSERT INTO JE_HU_BALANCES_REPORT
545: (CATEGORY_ID
546: ,ASSET_ID
547: ,DISTRIBUTION_CCID
548: ,ADJUSTMENT_CCID