APPS.FII_AR_CUSTOMER_DIMENSION_PKG dependencies on HZ_MERGE_PARTY_HISTORY

Line 165: FROM HZ_Merge_Party_History;

161: FII_UTIL.put_line(g_state);
162: end if;
163:
164: SELECT nvl(MAX(Batch_Party_ID), -1) INTO l_max_batch_party_id
165: FROM HZ_Merge_Party_History;
166:
167: UPDATE FII_Change_Log
168: SET (Item_Value, Last_Update_Date, Last_Update_Login, Last_Updated_By)
169: = (SELECT l_max_batch_party_id, sysdate, g_fii_login_id, g_fii_user_id FROM DUAL)

Line 573: FROM HZ_Merge_Party_History

569: FII_UTIL.put_line(g_state);
570: end if;
571:
572: SELECT nvl(MAX(Batch_Party_ID), -1) INTO l_max_batch_party_id
573: FROM HZ_Merge_Party_History
574: WHERE Batch_Party_ID >= l_prev_max_batch_party_id;
575:
576: IF l_max_batch_party_id > l_prev_max_batch_party_id THEN
577:

Line 597: FROM HZ_Merge_Party_History M,

593: WHEN (1=1)
594: THEN INTO FII_AR_Parties_Delta_GT(Party_ID, Type_ID)
595: VALUES (To_Entity_ID, 6)
596: SELECT From_Entity_ID, To_Entity_ID
597: FROM HZ_Merge_Party_History M,
598: HZ_Merge_Dictionary D
599: WHERE M.merge_dict_id = D.merge_dict_id
600: AND M.batch_party_id > l_prev_max_batch_party_id
601: AND M.batch_party_id <= l_max_batch_party_id