APPS.OZF_PRICELIST_PVT dependencies on DUAL

Line 1159: FROM DUAL

1155: l_item_in_prl VARCHAR2(1) := 'N';
1156:
1157: CURSOR c_item_in_prl IS
1158: SELECT 'Y'
1159: FROM DUAL
1160: WHERE EXISTS(SELECT 1
1161: FROM qp_pricing_attributes
1162: WHERE product_attribute = 'PRICING_ATTRIBUTE1'
1163: AND product_attr_value = p_inv_item_id

Line 1238: FROM DUAL;

1234:
1235:
1236: CURSOR c_list_line_id IS
1237: SELECT qp_list_lines_s.NEXTVAL
1238: FROM DUAL;
1239:
1240: CURSOR c_pricing_attr_id IS
1241: SELECT qp_pricing_attributes_s.NEXTVAL
1242: FROM DUAL;

Line 1242: FROM DUAL;

1238: FROM DUAL;
1239:
1240: CURSOR c_pricing_attr_id IS
1241: SELECT qp_pricing_attributes_s.NEXTVAL
1242: FROM DUAL;
1243:
1244: l_list_line_id NUMBER;
1245: l_pricing_attr_id NUMBER;
1246: