APPS.HZ_STAGE_MAP_TRANSFORM dependencies on DUAL

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

1519: END LOOP;
1520: FORALL I in H_C_PARTY_ID.FIRST..H_C_PARTY_ID.LAST
1521: INSERT INTO HZ_DQM_STAGE_GT(PARTY_ID,OWNER_ID,ORG_CONTACT_ID,PARTY_INDEX)
1522: SELECT H_C_PARTY_ID(I), H_R_PARTY_ID(I), H_ORG_CONTACT_ID(I), H_PARTY_INDEX(I)
1523: FROM DUAL WHERE H_R_PARTY_ID(I) IS NOT NULL;
1524: IF l_last_fetch THEN
1525: EXIT;
1526: END IF;
1527: END LOOP;

Line 3324: FROM dual ) T

3320: MERGE INTO hz_dqm_sh_sync_interface S
3321: USING (
3322: SELECT
3323: H_P_PARTY_ID(I) AS party_id
3324: FROM dual ) T
3325: ON (S.entity = 'PARTY' AND
3326: S.party_id = T.party_id AND
3327: S.staged_flag <> 'E')
3328: WHEN NOT MATCHED THEN

Line 3664: FROM dual ) T

3660: SELECT
3661: H_PS_PARTY_ID(I) AS party_id
3662: ,H_PARTY_SITE_ID(I) AS record_id
3663: ,H_PS_ORG_CONTACT_ID(I) AS org_contact_id
3664: FROM dual ) T
3665: ON (S.entity = 'PARTY_SITES' AND
3666: S.party_id = T.party_id AND
3667: S.record_id = T.record_id AND
3668: NVL(S.org_contact_id, -99) = NVL(T.org_contact_id, -99) AND

Line 3939: FROM dual ) T

3935: USING (
3936: SELECT
3937: H_C_PARTY_ID(I) AS party_id
3938: ,H_ORG_CONTACT_ID(I) AS record_id
3939: FROM dual ) T
3940: ON (S.entity = 'CONTACTS' AND
3941: S.party_id = T.party_id AND
3942: S.record_id = T.record_id AND
3943: S.staged_flag <> 'E')

Line 4256: FROM dual ) T

4252: H_CPT_PARTY_ID(I) AS party_id
4253: ,H_CONTACT_POINT_ID(I) AS record_id
4254: ,H_CPT_PARTY_SITE_ID(I) AS party_site_id
4255: ,H_CPT_ORG_CONTACT_ID(I) AS org_contact_id
4256: FROM dual ) T
4257: ON (S.entity = 'CONTACT_POINTS' AND
4258: S.party_id = T.party_id AND
4259: S.record_id = T.record_id AND
4260: NVL(S.party_site_id, -99) = NVL(T.party_site_id, -99) AND