283: || Change History :
284: || Who When What
285: || (reverse chronological order - newest change first)
286: */
287: CURSOR cur_rowid (p_person_id igr_i_a_lines_v.person_id%TYPE ,
288: p_enquiry_appl_number igr_i_a_lines_v.enquiry_appl_number%TYPE ,
289: p_product_category_id igr_i_a_lines_v.product_category_id%TYPE,
290: p_product_category_set_id igr_i_a_lines_v.product_category_set_id%TYPE,
291: l_rowid VARCHAR2) IS
284: || Who When What
285: || (reverse chronological order - newest change first)
286: */
287: CURSOR cur_rowid (p_person_id igr_i_a_lines_v.person_id%TYPE ,
288: p_enquiry_appl_number igr_i_a_lines_v.enquiry_appl_number%TYPE ,
289: p_product_category_id igr_i_a_lines_v.product_category_id%TYPE,
290: p_product_category_set_id igr_i_a_lines_v.product_category_set_id%TYPE,
291: l_rowid VARCHAR2) IS
292: SELECT row_id
285: || (reverse chronological order - newest change first)
286: */
287: CURSOR cur_rowid (p_person_id igr_i_a_lines_v.person_id%TYPE ,
288: p_enquiry_appl_number igr_i_a_lines_v.enquiry_appl_number%TYPE ,
289: p_product_category_id igr_i_a_lines_v.product_category_id%TYPE,
290: p_product_category_set_id igr_i_a_lines_v.product_category_set_id%TYPE,
291: l_rowid VARCHAR2) IS
292: SELECT row_id
293: FROM igr_i_a_lines_v
286: */
287: CURSOR cur_rowid (p_person_id igr_i_a_lines_v.person_id%TYPE ,
288: p_enquiry_appl_number igr_i_a_lines_v.enquiry_appl_number%TYPE ,
289: p_product_category_id igr_i_a_lines_v.product_category_id%TYPE,
290: p_product_category_set_id igr_i_a_lines_v.product_category_set_id%TYPE,
291: l_rowid VARCHAR2) IS
292: SELECT row_id
293: FROM igr_i_a_lines_v
294: WHERE person_id = p_person_id
289: p_product_category_id igr_i_a_lines_v.product_category_id%TYPE,
290: p_product_category_set_id igr_i_a_lines_v.product_category_set_id%TYPE,
291: l_rowid VARCHAR2) IS
292: SELECT row_id
293: FROM igr_i_a_lines_v
294: WHERE person_id = p_person_id
295: AND enquiry_appl_number = p_enquiry_appl_number
296: AND product_category_id = p_product_category_id
297: AND product_category_set_id = p_product_category_set_id