DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on HZ_PARTY_SITE_NUMBER_S

Line 538: nvl(party_site_number, hz_party_site_number_s.nextval),

534: :9,
535: party_site_id,
536: party_id,
537: hr_locations_s.NextVal,
538: nvl(party_site_number, hz_party_site_number_s.nextval),
539: site_orig_system_reference,
540: ''A'',
541: 1,
542: nvl(primary_flag, ''N''),

Line 2262: hz_party_site_number_s.NextVal,

2258: ( select
2259: l_new_site_id(j),
2260: l_party_id(j),
2261: l_new_loc_id(j),
2262: hz_party_site_number_s.NextVal,
2263: P_DML_RECORD.SYSDATE, P_DML_RECORD.USER_ID, P_DML_RECORD.SYSDATE, P_DML_RECORD.USER_ID, P_DML_RECORD.USER_ID,
2264: P_DML_RECORD.REQUEST_ID,
2265: P_DML_RECORD.PROGRAM_APPLICATION_ID, P_DML_RECORD.PROGRAM_ID, P_DML_RECORD.SYSDATE,
2266: l_site_orig_system_reference(j),