APPS.HZ_IMP_LOAD_BATCH_COUNTS_PKG dependencies on HZ_IMP_PARTIES_INT

Line 72: FROM HZ_IMP_PARTIES_INT INT

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
73: WHERE INT.BATCH_ID = P_BATCH_ID AND
74: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM ;
75: l_total_batch_records :=
76: l_ADDRESSUSES_IN_BATCH +

Line 367: from hz_imp_tmp_errors e, hz_imp_parties_sg sg,hz_parties hp, HZ_IMP_PARTIES_INT hzint

363: and hzint.interface_status(+) = 'D'
364: union all
365: select /*+ full(sg) parallel(sg) */ nvl2(e.int_row_id,
366: 1, nvl2(NVL(hp.party_id,hzint.BATCH_ID),decode(sg.action_flag, 'I', 12, 13),24)) a
367: from hz_imp_tmp_errors e, hz_imp_parties_sg sg,hz_parties hp, HZ_IMP_PARTIES_INT hzint
368: where sg.batch_mode_flag = p_batch_mode_flag
369: and sg.batch_id = p_batch_id
370: and sg.party_orig_system = p_original_system
371: and e.int_row_id (+) = sg.int_row_id

Line 373: and e.interface_table_name (+) = 'HZ_IMP_PARTIES_INT'

369: and sg.batch_id = p_batch_id
370: and sg.party_orig_system = p_original_system
371: and e.int_row_id (+) = sg.int_row_id
372: and e.request_id (+) = p_request_id
373: and e.interface_table_name (+) = 'HZ_IMP_PARTIES_INT'
374: and hp.party_id (+) = sg.party_id
375: and hp.request_id (+) = p_request_id
376: and sg.int_row_id = hzint.rowid (+)
377: and hzint.interface_status(+) = 'D'

Line 727: FROM HZ_IMP_PARTIES_INT INT, HZ_IMP_PARTIES_SG SG

723: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
724: AND INT.ACTION_FLAG = 'I' ;
725: -- for l_NEW_UNIQUE_PARTIES
726: SELECT count(INT.BATCH_ID) into l_NEW_UNIQUE_PARTIES
727: FROM HZ_IMP_PARTIES_INT INT, HZ_IMP_PARTIES_SG SG
728: WHERE INT.BATCH_ID = P_BATCH_ID AND
729: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM AND
730: INT.BATCH_ID = SG.BATCH_ID AND
731: INT.PARTY_ORIG_SYSTEM = SG.PARTY_ORIG_SYSTEM AND

Line 854: FROM HZ_IMP_PARTIES_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
854: FROM HZ_IMP_PARTIES_INT INT
855: WHERE INT.BATCH_ID = P_BATCH_ID AND
856: INT.PARTY_ORIG_SYSTEM = P_ORIGINAL_SYSTEM
857: AND INT.INTERFACE_STATUS = 'R' ;
858: