APPS.HZ_IMP_LOAD_FINREPORTS_PKG dependencies on HZ_IMP_FINREPORTS_SG

Line 436: hz_imp_finreports_sg fr_sg,

432: nullif(fr_int.trial_balance_ind, :10) trial_balance_ind,
433: fr_int.type_of_financial_report, -- logical key, cannot be null or g-miss
434: nullif(fr_int.unbalanced_ind, :10) unbalanced_ind
435: FROM hz_imp_finreports_int fr_int,
436: hz_imp_finreports_sg fr_sg,
437: hz_parties hp,
438: fnd_lookup_values createdby_l
439: WHERE fr_sg.party_orig_system = :12
440: AND fr_sg.party_orig_system_reference between :13 AND :14

Line 628: from hz_imp_finreports_sg fr_sg

624: 'Y','Y','Y','Y','Y','Y','Y', 'Y',
625: 'Y','Y','Y','Y','Y','Y','Y', 'Y',
626: 'Y',
627: other_exp_val, 'Y'
628: from hz_imp_finreports_sg fr_sg
629: where fr_sg.action_flag = 'I'
630: and fr_sg.batch_id = P_DML_RECORD.BATCH_ID
631: and fr_sg.party_orig_system = P_DML_RECORD.OS
632: and fr_sg.party_orig_system_reference

Line 835: hz_imp_finreports_sg fr_sg,

831: fr_sg.error_flag,
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