[Home] [Help]
3147: cursor c_upd_primary_address(p_pa_request_id IN NUMBER,
3148: p_address_id IN NUMBER)
3149: is
3150: SELECT pah.information1
3151: FROM ghr_pa_history pah
3152: WHERE pah.table_name = 'PER_ADDRESSES'
3153: AND pah.information1 = p_address_id
3154: AND pah.pa_request_id IN
3155: (