APPS.IGS_SV_NI_BATCH_PROCESS_PKG dependencies on HZ_LOCATIONS

Line 4596: FROM hz_locations lc, hz_party_sites st

4592: SUBSTR(address1||address2||address3||address4,1,60) addr_line2,
4593: SUBSTR(city,1,60) city ,
4594: SUBSTR(state,1,2) state ,
4595: postal_code
4596: FROM hz_locations lc, hz_party_sites st
4597: WHERE party_id = l_party_id
4598: AND lc.location_id = st.location_id
4599: AND identifying_address_flag ='Y';
4600:

Line 4601: l_postal_code hz_locations.postal_code%TYPE;

4597: WHERE party_id = l_party_id
4598: AND lc.location_id = st.location_id
4599: AND identifying_address_flag ='Y';
4600:
4601: l_postal_code hz_locations.postal_code%TYPE;
4602: l_not_valid BOOLEAN := FALSE;
4603: l_api_name CONSTANT VARCHAR(30) := 'Validate_Empl_Info';
4604: l_counter NUMBER(10):= 0;
4605: