APPS.POS_PROFILE_CHANGE_REQUEST_PKG dependencies on POS_ADDRESS_NOTES

Line 25: select address_req_id from pos_address_notes

21: WHERE address_req_id = p_request_rec.address_request_id for update nowait;
22: l_cont_addr_rec l_cont_addr_cur%ROWTYPE;
23:
24: cursor l_address_note_cur is
25: select address_req_id from pos_address_notes
26: WHERE address_req_id = p_request_rec.address_request_id for update nowait;
27: l_address_note_rec l_address_note_cur%ROWTYPE;
28:
29: BEGIN

Line 91: UPDATE pos_address_notes

87: rollback to approve_new_address_req;
88: RETURN;
89: END IF;
90:
91: UPDATE pos_address_notes
92: SET party_site_id = l_party_site_id
93: WHERE address_req_id = p_request_rec.address_request_id;
94:
95: UPDATE pos_address_requests