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;

Line 878: select HZ_CUST_SITE_USES_S.NEXTVAL into l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs(k).site_use_id from dual;

874: l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs.COUNT > 0 AND
875: l_su_profile = 'N') THEN
876: FOR k IN 1..l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs.COUNT LOOP
877: IF(l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs(k).location IS NULL) THEN
878: select HZ_CUST_SITE_USES_S.NEXTVAL into l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs(k).site_use_id from dual;
879: l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs(k).location := to_char(l_input_acct_obj.cust_acct_site_objs(j).cust_acct_site_use_objs(k).site_use_id);
880: END IF;
881: END LOOP;
882: END IF;