APPS.HZ_STAGE_MAP_TRANSFORM dependencies on DUAL

Line 1497: FROM DUAL WHERE H_R_PARTY_ID(I) IS NOT NULL;

1493: END LOOP;
1494: FORALL I in H_C_PARTY_ID.FIRST..H_C_PARTY_ID.LAST
1495: INSERT INTO HZ_DQM_STAGE_GT(PARTY_ID,OWNER_ID,ORG_CONTACT_ID,PARTY_INDEX)
1496: SELECT H_C_PARTY_ID(I), H_R_PARTY_ID(I), H_ORG_CONTACT_ID(I), H_PARTY_INDEX(I)
1497: FROM DUAL WHERE H_R_PARTY_ID(I) IS NOT NULL;
1498: IF l_last_fetch THEN
1499: EXIT;
1500: END IF;
1501: END LOOP;

Line 3298: FROM dual ) T

3294: MERGE INTO hz_dqm_sh_sync_interface S
3295: USING (
3296: SELECT
3297: H_P_PARTY_ID(I) AS party_id
3298: FROM dual ) T
3299: ON (S.entity = 'PARTY' AND
3300: S.party_id = T.party_id AND
3301: S.staged_flag <> 'E')
3302: WHEN NOT MATCHED THEN

Line 3638: FROM dual ) T

3634: SELECT
3635: H_PS_PARTY_ID(I) AS party_id
3636: ,H_PARTY_SITE_ID(I) AS record_id
3637: ,H_PS_ORG_CONTACT_ID(I) AS org_contact_id
3638: FROM dual ) T
3639: ON (S.entity = 'PARTY_SITES' AND
3640: S.party_id = T.party_id AND
3641: S.record_id = T.record_id AND
3642: NVL(S.org_contact_id, -99) = NVL(T.org_contact_id, -99) AND

Line 3913: FROM dual ) T

3909: USING (
3910: SELECT
3911: H_C_PARTY_ID(I) AS party_id
3912: ,H_ORG_CONTACT_ID(I) AS record_id
3913: FROM dual ) T
3914: ON (S.entity = 'CONTACTS' AND
3915: S.party_id = T.party_id AND
3916: S.record_id = T.record_id AND
3917: S.staged_flag <> 'E')

Line 4230: FROM dual ) T

4226: H_CPT_PARTY_ID(I) AS party_id
4227: ,H_CONTACT_POINT_ID(I) AS record_id
4228: ,H_CPT_PARTY_SITE_ID(I) AS party_site_id
4229: ,H_CPT_ORG_CONTACT_ID(I) AS org_contact_id
4230: FROM dual ) T
4231: ON (S.entity = 'CONTACT_POINTS' AND
4232: S.party_id = T.party_id AND
4233: S.record_id = T.record_id AND
4234: NVL(S.party_site_id, -99) = NVL(T.party_site_id, -99) AND