APPS.HZ_MERGE_PKG dependencies on HZ_STAGED_CONTACT_POINTS

Line 1278: SELECT CONTACT_POINT_ID FROM HZ_STAGED_CONTACT_POINTS

1274:
1275: IF (l_to_id IS NULL OR l_to_id = FND_API.G_MISS_NUM OR
1276: l_to_id = p_from_id) THEN
1277: FOR CPT IN (
1278: SELECT CONTACT_POINT_ID FROM HZ_STAGED_CONTACT_POINTS
1279: WHERE CONTACT_POINT_ID=p_from_id) LOOP
1280:
1281: HZ_DQM_SYNC.stage_contact_point_merge(
1282: 'HZ_STAGED_CONTACT_POINTS',

Line 1282: 'HZ_STAGED_CONTACT_POINTS',

1278: SELECT CONTACT_POINT_ID FROM HZ_STAGED_CONTACT_POINTS
1279: WHERE CONTACT_POINT_ID=p_from_id) LOOP
1280:
1281: HZ_DQM_SYNC.stage_contact_point_merge(
1282: 'HZ_STAGED_CONTACT_POINTS',
1283: p_from_id,l_dummy_id,p_from_id,p_from_id,
1284: 'HZ_CONTACT_POINTS',
1285: p_batch_id,p_batch_party_id,x_return_status);
1286: END LOOP;

Line 2388: SELECT CONTACT_POINT_ID FROM HZ_STAGED_CONTACT_POINTS

2384:
2385: IF (l_to_id IS NULL OR l_to_id = FND_API.G_MISS_NUM OR
2386: l_to_id = p_from_id) THEN
2387: FOR CPT IN (
2388: SELECT CONTACT_POINT_ID FROM HZ_STAGED_CONTACT_POINTS
2389: WHERE CONTACT_POINT_ID=p_from_id) LOOP
2390:
2391: HZ_DQM_SYNC.stage_contact_point_merge(
2392: 'HZ_STAGED_CONTACT_POINTS',

Line 2392: 'HZ_STAGED_CONTACT_POINTS',

2388: SELECT CONTACT_POINT_ID FROM HZ_STAGED_CONTACT_POINTS
2389: WHERE CONTACT_POINT_ID=p_from_id) LOOP
2390:
2391: HZ_DQM_SYNC.stage_contact_point_merge(
2392: 'HZ_STAGED_CONTACT_POINTS',
2393: p_from_id,l_dummy_id,p_from_id,p_from_id,
2394: 'HZ_CONTACT_POINTS',
2395: p_batch_id,p_batch_party_id,x_return_status);
2396: END LOOP;