DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_FINNUMBERS_PKG dependencies on HZ_IMP_FINNUMBERS_SG

Line 171: hz_imp_finnumbers_sg fn_sg

167: fn_int.CREATED_BY_MODULE,
168: decode(nvl(fn_int.insert_update_flag, fn_sg.action_flag), fn_sg.action_flag, ''Y'', null),
169: fn_sg.error_flag
170: FROM hz_imp_finnumbers_int fn_int,
171: hz_imp_finnumbers_sg fn_sg
172: WHERE fn_sg.batch_id = :BATCH_ID
173: and fn_sg.batch_mode_flag = :BATCH_MODE_FLAG
174: and fn_sg.party_orig_system = :WU_OS
175: and fn_sg.party_orig_system_reference between :FROM_OSR AND :TO_OSR

Line 341: hz_imp_finnumbers_sg fn_sg,

337: trunc(hz_fr.REPORT_START_DATE)
338: and trunc(fn_sg.REPORT_END_DATE) =
339: trunc(hz_fr.REPORT_END_DATE) then 2 end ranking
340: from hz_imp_finnumbers_int fn_int,
341: hz_imp_finnumbers_sg fn_sg,
342: fnd_lookup_values fin_num_l,
343: hz_financial_reports hz_fr,
344: fnd_lookup_values createdby_l
345: where fn_sg.batch_id = :9

Line 514: from hz_imp_finnumbers_sg fn_sg

510: other_exp_val,
511: -- this function report errors for exception
512: -- not checking all other potential errors
513: 'Y', 'Y', 'Y'
514: from hz_imp_finnumbers_sg fn_sg
515: where fn_sg.action_flag = 'I'
516: and fn_sg.batch_id = P_DML_RECORD.BATCH_ID
517: and fn_sg.party_orig_system = P_DML_RECORD.OS
518: and fn_sg.party_orig_system_reference