APPS.HZ_IMP_LOAD_ADDRESSES_PKG dependencies on HZ_LOCATION_PROFILES_S

Line 725: hz_location_profiles_s.nextval,

721: :4,
722: :5,
723: :6,
724: hr_locations_s.NextVal,
725: hz_location_profiles_s.nextval,
726: address1,
727: address2,
728: address3,
729: address4,

Line 787: hz_location_profiles_s.nextval+1,

783: :4,
784: :5,
785: :6,
786: hr_locations_s.NextVal,
787: hz_location_profiles_s.nextval+1,
788: address1_std,
789: address2_std,
790: address3_std,
791: address4_std,

Line 2496: hz_location_profiles_s.NextVal,

2492: PROGRAM_UPDATE_DATE
2493: )
2494: ( select
2495: decode(l_move_count(j), 1, l_new_loc_id(j), l_location_id(j)),
2496: hz_location_profiles_s.NextVal,
2497: nvl(l_addr1(j), l_old_addr1(j)),
2498: nullif(nvl(l_addr2(j), l_old_addr2(j)), P_DML_RECORD.GMISS_CHAR),
2499: nullif(nvl(l_addr3(j), l_old_addr3(j)), P_DML_RECORD.GMISS_CHAR),
2500: nullif(nvl(l_addr4(j), l_old_addr4(j)), P_DML_RECORD.GMISS_CHAR),

Line 2634: hz_location_profiles_s.NextVal,

2630: PROGRAM_ID,
2631: PROGRAM_UPDATE_DATE
2632: )
2633: ( select
2634: hz_location_profiles_s.NextVal,
2635: decode(l_move_count(j), 1, l_new_loc_id(j), l_location_id(j)),
2636: l_addr1_std(j),
2637: l_addr2_std(j),
2638: l_addr3_std(j),

Line 2693: hz_location_profiles_s.NextVal,

2689: PROGRAM_ID,
2690: PROGRAM_UPDATE_DATE
2691: )
2692: ( select
2693: hz_location_profiles_s.NextVal,
2694: decode(l_move_count(j), 1, l_new_loc_id(j), l_location_id(j)),
2695: l_addr1_std(j),
2696: l_addr2_std(j),
2697: l_addr3_std(j),