APPS.HZ_AIA_CUSTOM_PKG dependencies on DUAL

Line 459: from dual;

455: and r2.relationship_id = oc2.party_relationship_id
456: and r2.subject_Type = 'PERSON' and r2.object_type = 'ORGANIZATION'
457: and md.entity_name = 'HZ_CUST_ACCOUNT_ROLES'
458: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ))
459: from dual;
460:
461: CURSOR get_person_merge_detail(l_batch_id NUMBER, l_party_type VARCHAR2) IS
462: SELECT CRMINTEG_HZ_MERGE_OBJ(
463: l_party_type, -- party_type

Line 499: from dual;

495: and r2.relationship_id = oc2.party_relationship_id
496: and r2.subject_Type = 'PERSON' and r2.object_type = 'ORGANIZATION'
497: and md.entity_name = 'HZ_CUST_ACCOUNT_ROLES'
498: ) AS CRMINTEG_HZ_MRGDTIL_OBJ_TBL ))
499: from dual;
500:
501: l_debug_prefix VARCHAR2(30);
502: l_party_type VARCHAR2(30);
503: l_from_party_id NUMBER;