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 2221: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;

2217: )
2218: IS
2219:
2220: l_step NUMBER;
2221: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
2222: l_lock_id NUMBER;
2223:
2224: BEGIN
2225:

Line 2781: from hz_party_sites

2777: and request_status = 'PENDING'
2778: and nvl(party_site_id, -1) in
2779: (
2780: select party_site_id
2781: from hz_party_sites
2782: where location_id in
2783: (
2784: select location_id
2785: from hz_party_sites

Line 2785: from hz_party_sites

2781: from hz_party_sites
2782: where location_id in
2783: (
2784: select location_id
2785: from hz_party_sites
2786: where party_site_id = nvl(p_party_site_id, -1)
2787: )
2788: ) FOR UPDATE NOWAIT;
2789: l_req_rec_exists_rec req_rec_exists%ROWTYPE;