APPS.HZ_IMP_LOAD_FINREPORTS_PKG dependencies on HZ_FINANCIAL_REPORTS

Line 217: into hz_financial_reports (

213: and date_comb_err is not null
214: and rpt_date_err is not null
215: and createdby_error is not null
216: ) then
217: into hz_financial_reports (
218: actual_content_source,
219: content_source_type,
220: created_by,
221: creation_date,

Line 713: update hz_financial_reports set

709: l_rpt_date_flag;
710: close c_update_cursor;
711:
712: forall j in 1..l_fr_id.count
713: update hz_financial_reports set
714: PROGRAM_ID = P_DML_RECORD.PROGRAM_ID,
715: PROGRAM_APPLICATION_ID = P_DML_RECORD.PROGRAM_APPLICATION_ID,
716: PROGRAM_UPDATE_DATE = P_DML_RECORD.SYSDATE,
717: REQUEST_ID = P_DML_RECORD.REQUEST_ID,

Line 836: hz_financial_reports hz_fr

832: nvl2(fr_int.ISSUED_PERIOD, nvl2(fr_int.REPORT_START_DATE, null, ''Y''), nvl2(fr_int.REPORT_START_DATE, ''Y'', null)) date_comb_err,
833: nvl2(fr_int.REPORT_START_DATE, nvl2(fr_int.REPORT_END_DATE, ''Y'', null), nvl2(fr_int.REPORT_END_DATE, null, ''Y'')) rpt_date_err
834: FROM hz_imp_finreports_int fr_int,
835: hz_imp_finreports_sg fr_sg,
836: hz_financial_reports hz_fr
837: WHERE fr_sg.batch_id = :P_BATCH_ID
838: AND fr_sg.batch_mode_flag = :BATCH_MODE_FLAG
839: AND fr_sg.party_orig_system = :P_OS
840: AND fr_sg.party_orig_system_reference between :P_FROM_OSR AND :TO_OSR