APPS.POS_VENDOR_REG_PKG dependencies on POS_ADDRESS_REQUESTS

Line 447: FROM pos_address_requests par

443: x_msg_data OUT nocopy VARCHAR2
444: ) IS
445: CURSOR l_cur IS
446: SELECT par.address_request_id
447: FROM pos_address_requests par
448: , pos_supplier_mappings psm
449: WHERE par.request_type = 'ADD'
450: AND par.request_status = 'PENDING'
451: AND par.mapping_id = psm.mapping_id

Line 1221: UPDATE pos_address_requests

1217: last_updated_by = fnd_global.user_id,
1218: last_update_login = fnd_global.login_id
1219: WHERE supplier_reg_id = p_supplier_reg_id;
1220:
1221: UPDATE pos_address_requests
1222: SET request_status = 'REJECTED',
1223: last_update_date = Sysdate,
1224: last_updated_by = fnd_global.user_id,
1225: last_update_login = fnd_global.login_id