DBA Data[Home] [Help]

APPS.HZ_DQM_SYNC dependencies on DUAL

Line 1073: FROM dual ) T

1069: ,p_party_id AS party_id
1070: ,p_record_id AS record_id
1071: ,p_party_site_id AS party_site_id
1072: ,p_org_contact_id AS org_contact_id
1073: FROM dual ) T
1074: ON (S.entity = T.entity AND
1075: S.party_id = T.party_id AND
1076: NVL(S.record_id,-99) = NVL(T.record_id,-99) AND
1077: NVL(S.party_site_id, -99) = NVL(T.party_site_id,-99) AND

Line 1182: FROM dual ) T

1178: ,p_party_id AS party_id
1179: ,p_record_id AS record_id
1180: ,p_party_site_id AS party_site_id
1181: ,p_org_contact_id AS org_contact_id
1182: FROM dual ) T
1183: ON (S.entity = T.entity AND
1184: S.party_id = T.party_id AND
1185: NVL(S.record_id,-99) = NVL(T.record_id,-99) AND
1186: NVL(S.party_site_id, -99) = NVL(T.party_site_id,-99) AND