APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on HZ_PARTY_SITES

Line 156: FROM hz_party_sites

152: SELECT object_version_number,location_id
153: from hz_locations
154: where location_id =
155: (SELECT location_id
156: FROM hz_party_sites
157: WHERE party_site_id = p_request_rec.party_site_id
158: ) FOR UPDATE;
159:
160: l_rec l_cur%ROWTYPE;

Line 164: from hz_party_sites

160: l_rec l_cur%ROWTYPE;
161:
162: CURSOR l_cur2 IS
163: select object_version_number, party_site_name
164: from hz_party_sites
165: where party_site_id = p_request_rec.party_site_id FOR UPDATE;
166:
167: l_rec2 l_cur2%ROWTYPE;
168: l_lock_id NUMBER;

Line 2275: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;

2271: )
2272: IS
2273:
2274: l_step NUMBER;
2275: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
2276: l_lock_id NUMBER;
2277:
2278: BEGIN
2279:

Line 2855: from hz_party_sites

2851: and request_status = 'PENDING'
2852: and nvl(party_site_id, -1) in
2853: (
2854: select party_site_id
2855: from hz_party_sites
2856: where location_id in
2857: (
2858: select location_id
2859: from hz_party_sites

Line 2859: from hz_party_sites

2855: from hz_party_sites
2856: where location_id in
2857: (
2858: select location_id
2859: from hz_party_sites
2860: where party_site_id = nvl(p_party_site_id, -1)
2861: )
2862: ) FOR UPDATE NOWAIT;
2863: l_req_rec_exists_rec req_rec_exists%ROWTYPE;