APPS.IGS_SV_BATCH_PROCESS_PKG dependencies on HZ_PARTY_SITES

Line 163: l_party_id HZ_PARTY_SITES.PARTY_ID%TYPE;

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

Line 164: l_party_site_id HZ_PARTY_SITES.PARTY_SITE_ID%TYPE;

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

Line 1046: hz_party_sites ps,

1042: CURSOR c_soa_exists(cp_person_id igs_sv_addresses.person_id%TYPE, cp_party_site_id igs_sv_addresses.party_site_id%TYPE)
1043: IS
1044: SELECT 1
1045: FROM hz_locations loc,
1046: hz_party_sites ps,
1047: igs_pe_hz_pty_sites igsps,
1048: hz_party_site_uses usg
1049: WHERE
1050: ps.location_id = loc.location_id

Line 2470: HZ_PARTY_SITES ps,

2466: ps.identifying_address_flag primary_site,
2467: to_char(usg.party_site_id) activity_site_cd,
2468: null remarks
2469: FROM HZ_LOCATIONS loc,
2470: HZ_PARTY_SITES ps,
2471: IGS_PE_HZ_PTY_SITES IGSPS,
2472: hz_party_site_uses usg
2473: WHERE
2474: PS.LOCATION_ID = Loc.LOCATION_ID

Line 2522: HZ_PARTY_SITES ps,

2518: ps.identifying_address_flag primary_site,
2519: to_char(usg.party_site_id) activity_site_cd ,
2520: null remarks
2521: from HZ_LOCATIONS loc,
2522: HZ_PARTY_SITES ps,
2523: IGS_PE_HZ_PTY_SITES IGSPS,
2524: hz_party_site_uses usg
2525: where
2526: PS.LOCATION_ID = Loc.LOCATION_ID

Line 5552: FROM hz_locations lc, hz_party_sites st

5548: SUBSTR(address1||address2||address3||address4,1,60) addr_line2,
5549: SUBSTR(city,1,60) city ,
5550: SUBSTR(state,1,2) state ,
5551: postal_code
5552: FROM hz_locations lc, hz_party_sites st
5553: WHERE party_id = l_party_id
5554: AND lc.location_id = st.location_id
5555: AND identifying_address_flag ='Y';
5556: