APPS.HZ_IMP_LOAD_CPT_PKG dependencies on DUAL

Line 517: from dual

513: nvl2(l_party_orig_system_reference(j),'P',nvl2(l_site_orig_system_reference(j),'S','P')),'Y'),
514: l_cp_purpose_web_err(j),
515: l_third_party_update_error(j),
516: l_createdby_errors(j)
517: from dual
518: where l_num_row_processed(j) = 0
519: );
520:
521: EXCEPTION

Line 1004: (select 0 a from dual union all select 1 a from dual) tc,--3401319

1000: --hz_orig_sys_references mosr_party,
1001: hz_parties hp,
1002: hz_orig_sys_references mosr_site,
1003: --(select distinct phone_country_code from hz_phone_country_codes) hpc,--3401319
1004: (select 0 a from dual union all select 1 a from dual) tc,--3401319
1005: fnd_timezones_b ht,
1006: fnd_lookup_values contact_point_type_l,
1007: fnd_lookup_values email_format_l,
1008: fnd_lookup_values cp_purpose_l,

Line 1487: (select 0 a from dual union all select 1 a from dual) tc,--3401319

1483:
1484: FROM HZ_IMP_CONTACTPTS_INT pi, HZ_IMP_CONTACTPTS_SG ps,hz_contact_points hp,
1485: hz_orig_systems_b hos, /* Bug 4079902 */
1486: --(select distinct phone_country_code from hz_phone_country_codes) hpc,--3401319
1487: (select 0 a from dual union all select 1 a from dual) tc,--3401319
1488: fnd_timezones_b ht,fnd_lookup_values contact_point_type_l,
1489: fnd_lookup_values email_format_l,fnd_lookup_values cp_purpose_l,
1490: fnd_lookup_values cp_purpose_web_l,fnd_lookup_values phone_line_type_l,
1491: fnd_lookup_values createdby_l

Line 1969: from dual

1965: P_DML_RECORD.LAST_UPDATE_LOGIN,
1966: nvl(l_created_by_module(j), 'HZ_IMPORT'),
1967: P_DML_RECORD.APPLICATION_ID,
1968: 1
1969: from dual
1970: where
1971: l_old_cp_orig_system_ref(j) is not null
1972: and l_num_row_processed(j) = 1
1973: and l_cp_orig_system_reference(j) <> l_old_cp_orig_system_ref(j);