50: CURSOR to_rltd_modifier_id_cur(a_list_line_id NUMBER,
51: a_rltd_modifier_grp_type VARCHAR2)
52: IS
53: select to_rltd_modifier_id
54: from qp_rltd_modifiers
55: where to_rltd_modifier_id = a_list_line_id
56: and rltd_modifier_grp_type = a_rltd_modifier_grp_type;
57:
58: -- SELECT list_line_type_code
956: BEGIN
957:
958: select count(*)
959: into l_count
960: from qp_rltd_modifiers
961: where to_rltd_modifier_id = p_PRICING_ATTR_rec.list_line_id;
962:
963: EXCEPTION
964: when no_data_found then
1049: SELECT LIST_LINE_TYPE_CODE
1050: INTO l_primary_list_line_type_code
1051: FROM QP_LIST_LINES
1052: WHERE LIST_LINE_ID = ( select from_rltd_modifier_id
1053: from qp_rltd_modifiers
1054: where to_rltd_modifier_id
1055: = p_PRICING_ATTR_rec.list_line_id);
1056:
1057: EXCEPTION