DBA Data[Home] [Help]

APPS.QP_VALIDATE_PRICING_ATTR dependencies on QP_RLTD_MODIFIERS

Line 54: from qp_rltd_modifiers

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

Line 960: from qp_rltd_modifiers

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

Line 1053: from qp_rltd_modifiers

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