DBA Data[Home] [Help]

APPS.HZ_DQM_SYNC dependencies on DUAL

Line 1062: FROM dual ) T

1058: ,p_party_id AS party_id
1059: ,p_record_id AS record_id
1060: ,p_party_site_id AS party_site_id
1061: ,p_org_contact_id AS org_contact_id
1062: FROM dual ) T
1063: ON (S.entity = T.entity AND
1064: S.party_id = T.party_id AND
1065: NVL(S.record_id,-99) = NVL(T.record_id,-99) AND
1066: NVL(S.party_site_id, -99) = NVL(T.party_site_id,-99) AND

Line 1135: FROM dual ) T

1131: ,p_party_id AS party_id
1132: ,p_record_id AS record_id
1133: ,p_party_site_id AS party_site_id
1134: ,p_org_contact_id AS org_contact_id
1135: FROM dual ) T
1136: ON (S.entity = T.entity AND
1137: S.party_id = T.party_id AND
1138: NVL(S.record_id,-99) = NVL(T.record_id,-99) AND
1139: NVL(S.party_site_id, -99) = NVL(T.party_site_id,-99) AND