APPS.JE_JEHUFAMD_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 482: DELETE FROM JE_HU_BALANCES_REPORT;

478: CP_BALANCE_TYPE := 'CR';
479: ELSE
480: CP_BALANCE_TYPE := 'DR';
481: END IF;
482: DELETE FROM JE_HU_BALANCES_REPORT;
483: DELETE FROM FA_LOOKUPS_B
484: WHERE LOOKUP_TYPE = 'REPORT TYPE';
485: DELETE FROM FA_LOOKUPS_TL
486: WHERE LOOKUP_TYPE = 'REPORT TYPE';

Line 536: INSERT INTO JE_HU_BALANCES_REPORT

532: END INSERT_INFO;
533:
534: PROCEDURE GET_BALANCE IS
535: BEGIN
536: INSERT INTO JE_HU_BALANCES_REPORT
537: (CATEGORY_ID
538: ,ASSET_ID
539: ,DISTRIBUTION_CCID
540: ,ADJUSTMENT_CCID