APPS.HZ_IMP_LOAD_PARTIES_PKG dependencies on DUAL

Line 551: from dual

547: l_party_name_update_errors(j), -- Bug 5146904
548: nvl2(l_action_mismatch_errors(j),'Y',null), --HZ_IMP_ACTION_MISMATCH
549: l_dup_val_exists(j),
550: l_exception_exists(j)
551: from dual
552: where l_num_row_processed(j) = 0
553: );
554:
555: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 6126: from dual

6122: P_DML_RECORD.APPLICATION_ID, --APPLICATION_ID,
6123: decode(l_do_not_confuse_with(j), P_DML_RECORD.GMISS_CHAR, NULL,
6124: l_do_not_confuse_with(j)),
6125: l_actual_content_source -- ACTUAL_CONTENT_SOURCE
6126: from dual
6127: where
6128: l_num_row_processed(j) = 1
6129: and l_party_type(j) = 'ORGANIZATION'
6130: and not exists (select 1 from hz_organization_profiles op2

Line 6298: from dual

6294: P_DML_RECORD.GMISS_CHAR, decode(l_date_of_death(j), null, 'N', P_DML_RECORD.GMISS_DATE, 'N', 'Y'),
6295: l_deceased_flag(j)),
6296: decode(l_created_by_module(j), P_DML_RECORD.GMISS_CHAR, 'HZ_IMPORT',
6297: NULL, 'HZ_IMPORT', l_created_by_module(j))
6298: from dual
6299: where
6300: l_num_row_processed(j) = 1
6301: and l_party_type(j) = 'PERSON'
6302: and not exists (select 1 from hz_person_profiles pp2 -- Bug 6398209

Line 9037: from dual

9033: P_DML_RECORD.APPLICATION_ID, --APPLICATION_ID,
9034: decode(l_do_not_confuse_with(j), P_DML_RECORD.GMISS_CHAR, NULL,
9035: l_do_not_confuse_with(j)),
9036: l_actual_content_source -- ACTUAL_CONTENT_SOURCE
9037: from dual
9038: where
9039: l_num_row_processed(j) = 1
9040: and l_party_type(j) = 'ORGANIZATION'
9041: and not exists (select 1 from hz_organization_profiles op2

Line 9215: from dual

9211: P_DML_RECORD.GMISS_CHAR, decode(l_date_of_death(j), null, 'N', P_DML_RECORD.GMISS_DATE, 'N', 'Y'),
9212: l_deceased_flag(j)),
9213: decode(l_created_by_module(j), P_DML_RECORD.GMISS_CHAR, 'HZ_IMPORT',
9214: NULL, 'HZ_IMPORT', l_created_by_module(j))
9215: from dual
9216: where
9217: l_num_row_processed(j) = 1
9218: and l_party_type(j) = 'PERSON'
9219: and not exists (select 1 from hz_person_profiles pp2

Line 9315: from dual

9311: P_DML_RECORD.LAST_UPDATE_LOGIN,
9312: nvl(l_created_by_module(j), 'HZ_IMPORT'),
9313: P_DML_RECORD.APPLICATION_ID,
9314: 1
9315: from dual
9316: where
9317: l_old_orig_system_reference(j) is not null
9318: and l_num_row_processed(j) = 1;
9319:

Line 9366: from dual

9362: P_DML_RECORD.LAST_UPDATE_LOGIN,
9363: nvl(l_created_by_module(j), 'HZ_IMPORT'),
9364: P_DML_RECORD.APPLICATION_ID,
9365: 1
9366: from dual
9367: where
9368: l_old_orig_system_reference(j) is null
9369: and l_new_osr_exists(j) is not null
9370: and l_num_row_processed(j) = 1;