APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_FINREPORTS_INT

Line 68: FROM HZ_IMP_FINREPORTS_INT INT

64: FROM HZ_IMP_CREDITRTNGS_INT INT
65: WHERE INT.BATCH_ID = P_BATCH_ID AND
66: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
67: SELECT count(INT.BATCH_ID) into l_FINREPORTS_IN_BATCH
68: FROM HZ_IMP_FINREPORTS_INT INT
69: WHERE INT.BATCH_ID = P_BATCH_ID AND
70: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
71: SELECT count(INT.BATCH_ID) into l_PARTIES_IN_BATCH
72: FROM HZ_IMP_PARTIES_INT INT

Line 318: from hz_imp_tmp_errors e, hz_imp_finreports_sg sg,hz_financial_reports fnr, HZ_IMP_FINREPORTS_INT hzint

314: and hzint.interface_status(+) = 'D'
315: union all
316: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
317: 1, nvl2(NVL(fnr.financial_report_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 6, 7),24)) a
318: from hz_imp_tmp_errors e, hz_imp_finreports_sg sg,hz_financial_reports fnr, HZ_IMP_FINREPORTS_INT hzint
319: where sg.batch_mode_flag = p_batch_mode_flag
320: and sg.batch_id = p_batch_id
321: and sg.party_orig_system = p_original_system
322: and e.int_row_id (+) = sg.int_row_id

Line 324: and e.interface_table_name (+) = 'HZ_IMP_FINREPORTS_INT'

320: and sg.batch_id = p_batch_id
321: and sg.party_orig_system = p_original_system
322: and e.int_row_id (+) = sg.int_row_id
323: and e.request_id (+) = p_request_id
324: and e.interface_table_name (+) = 'HZ_IMP_FINREPORTS_INT'
325: and fnr.financial_report_id(+) = sg.financial_report_id
326: and fnr.request_id(+) = p_request_id
327: and sg.int_row_id = hzint.rowid (+)
328: and hzint.interface_status(+) = 'D'

Line 849: FROM HZ_IMP_FINREPORTS_INT INT

845: WHERE INT.BATCH_ID = P_BATCH_ID AND
846: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
847: AND INT.INTERFACE_STATUS = 'R' ;
848: SELECT count(INT.BATCH_ID) into l_REMOVED_FINREPORTS
849: FROM HZ_IMP_FINREPORTS_INT INT
850: WHERE INT.BATCH_ID = P_BATCH_ID AND
851: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
852: AND INT.INTERFACE_STATUS = 'R' ;
853: SELECT count(INT.BATCH_ID) into l_REMOVED_PARTIES