APPS.IGS_SV_NI_BATCH_PROCESS_PKG dependencies on HZ_PARTY_SITES

Line 161: l_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;

157:
158: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
159: l_event_name VARCHAR2(255);
160: l_event_key VARCHAR2(255);
161: l_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
162: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
163: l_trans_type VARCHAR2(30) :='IGS_SV';
164: l_trans_subtype VARCHAR2(30) ;
165: l_debug_level NUMBER := 0;

Line 162: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;

158: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
159: l_event_name VARCHAR2(255);
160: l_event_key VARCHAR2(255);
161: l_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;
162: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;
163: l_trans_type VARCHAR2(30) :='IGS_SV';
164: l_trans_subtype VARCHAR2(30) ;
165: l_debug_level NUMBER := 0;
166: l_user_id VARCHAR2(100);

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: