APPS.QP_QP_FORM_PLL_PRICING_ATTR dependencies on QP_PRICING_ATTRIBUTES

Line 1842: FROM QP_PRICING_ATTRIBUTES

1838: , PRODUCT_ATTRIBUTE_DATATYPE
1839: , PRICING_ATTR_VALUE_FROM_NUMBER
1840: , PRICING_ATTR_VALUE_TO_NUMBER
1841: , QUALIFICATION_IND
1842: FROM QP_PRICING_ATTRIBUTES
1843: WHERE LIST_LINE_ID = p_list_line_id
1844: AND PRICING_ATTRIBUTE_CONTEXT IS NOT NULL;
1845:
1846:

Line 1897: FROM QP_PRICING_ATTRIBUTES

1893: , PRODUCT_ATTRIBUTE_DATATYPE
1894: , PRICING_ATTR_VALUE_FROM_NUMBER
1895: , PRICING_ATTR_VALUE_TO_NUMBER
1896: , QUALIFICATION_IND
1897: FROM QP_PRICING_ATTRIBUTES
1898: WHERE LIST_LINE_ID = p_list_line_id;
1899:
1900:
1901: --added for related lines duplication

Line 1906: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id

1902:
1903: BEGIN
1904: FOR l_implicit_rec IN l_PRICING_ATTR_csr(p_x_old_list_line_id) LOOP
1905:
1906: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id
1907: FROM dual;
1908:
1909: l_PRICING_ATTR_rec.accumulate_flag := l_implicit_rec.ACCUMULATE_FLAG;
1910: l_PRICING_ATTR_rec.attribute1 := l_implicit_rec.ATTRIBUTE1;

Line 2064: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id FROM dual;

2060: -- Related Lines Pricing Attributes Duplication
2061:
2062: FOR l_implicit_attr_rec IN l_PRICING_ATTR_rltd_csr(l_implicit_rec.list_line_id) LOOP
2063:
2064: SELECT qp_pricing_attributes_s.nextval INTO l_new_pricing_attribute_id FROM dual;
2065:
2066: l_PRICING_ATTR_rec.accumulate_flag := l_implicit_attr_rec.ACCUMULATE_FLAG;
2067: l_PRICING_ATTR_rec.attribute1 := l_implicit_attr_rec.ATTRIBUTE1;
2068: l_PRICING_ATTR_rec.attribute10 := l_implicit_attr_rec.ATTRIBUTE10;