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 6144: from dual

6140: P_DML_RECORD.APPLICATION_ID, --APPLICATION_ID,
6141: decode(l_do_not_confuse_with(j), P_DML_RECORD.GMISS_CHAR, NULL,
6142: l_do_not_confuse_with(j)),
6143: l_actual_content_source -- ACTUAL_CONTENT_SOURCE
6144: from dual
6145: where
6146: l_num_row_processed(j) = 1
6147: and l_party_type(j) = 'ORGANIZATION'
6148: and not exists (select 1 from hz_organization_profiles op2

Line 6316: from dual

6312: P_DML_RECORD.GMISS_CHAR, decode(l_date_of_death(j), null, 'N', P_DML_RECORD.GMISS_DATE, 'N', 'Y'),
6313: l_deceased_flag(j)),
6314: decode(l_created_by_module(j), P_DML_RECORD.GMISS_CHAR, 'HZ_IMPORT',
6315: NULL, 'HZ_IMPORT', l_created_by_module(j))
6316: from dual
6317: where
6318: l_num_row_processed(j) = 1
6319: and l_party_type(j) = 'PERSON'
6320: and not exists (select 1 from hz_person_profiles pp2 -- Bug 6398209

Line 9055: from dual

9051: P_DML_RECORD.APPLICATION_ID, --APPLICATION_ID,
9052: decode(l_do_not_confuse_with(j), P_DML_RECORD.GMISS_CHAR, NULL,
9053: l_do_not_confuse_with(j)),
9054: l_actual_content_source -- ACTUAL_CONTENT_SOURCE
9055: from dual
9056: where
9057: l_num_row_processed(j) = 1
9058: and l_party_type(j) = 'ORGANIZATION'
9059: and not exists (select 1 from hz_organization_profiles op2

Line 9233: from dual

9229: P_DML_RECORD.GMISS_CHAR, decode(l_date_of_death(j), null, 'N', P_DML_RECORD.GMISS_DATE, 'N', 'Y'),
9230: l_deceased_flag(j)),
9231: decode(l_created_by_module(j), P_DML_RECORD.GMISS_CHAR, 'HZ_IMPORT',
9232: NULL, 'HZ_IMPORT', l_created_by_module(j))
9233: from dual
9234: where
9235: l_num_row_processed(j) = 1
9236: and l_party_type(j) = 'PERSON'
9237: and not exists (select 1 from hz_person_profiles pp2

Line 9333: from dual

9329: P_DML_RECORD.LAST_UPDATE_LOGIN,
9330: nvl(l_created_by_module(j), 'HZ_IMPORT'),
9331: P_DML_RECORD.APPLICATION_ID,
9332: 1
9333: from dual
9334: where
9335: l_old_orig_system_reference(j) is not null
9336: and l_num_row_processed(j) = 1;
9337:

Line 9384: from dual

9380: P_DML_RECORD.LAST_UPDATE_LOGIN,
9381: nvl(l_created_by_module(j), 'HZ_IMPORT'),
9382: P_DML_RECORD.APPLICATION_ID,
9383: 1
9384: from dual
9385: where
9386: l_old_orig_system_reference(j) is null
9387: and l_new_osr_exists(j) is not null
9388: and l_num_row_processed(j) = 1;