APPS.QP_PROCESS_OTHER_BENEFITS_PVT dependencies on QP_LIST_HEADERS_B

Line 322: FROM QP_LIST_HEADERS_B a ,QP_LIST_LINES b,QP_PRICING_ATTRIBUTES c

318: b.SERVICE_DURATION,b.SERVICE_PERIOD,-- SERVICE PROJECT
319: b.BENEFIT_QTY,b.LIST_PRICE,
320: b.PRICE_BREAK_TYPE_CODE,b.AUTOMATIC_FLAG, c.PRODUCT_ATTRIBUTE_CONTEXT, c.PRODUCT_ATTRIBUTE,
321: c.PRODUCT_ATTR_VALUE,c.PRODUCT_UOM_CODE , b.ACCRUAL_FLAG,b.MODIFIER_LEVEL_CODE
322: FROM QP_LIST_HEADERS_B a ,QP_LIST_LINES b,QP_PRICING_ATTRIBUTES c
323: WHERE a.LIST_HEADER_ID = b.LIST_HEADER_ID
324: AND b.LIST_LINE_ID = c.LIST_LINE_ID
325: AND b.LIST_LINE_ID= p_related_modifier_id;
326:

Line 337: FROM QP_LIST_LINES a ,QP_LIST_HEADERS_B b

333:
334:
335: CURSOR get_list_price_cur(p_line_id NUMBER) IS
336: SELECT a.LIST_HEADER_ID,a.LIST_LINE_ID,a.OPERAND,b.ROUNDING_FACTOR, a.ARITHMETIC_OPERATOR -- service project
337: FROM QP_LIST_LINES a ,QP_LIST_HEADERS_B b
338: WHERE a.LIST_LINE_ID = p_line_id
339: AND a.LIST_HEADER_ID = b.LIST_HEADER_ID;
340:
341: CURSOR get_request_type_code_cur IS

Line 853: FROM QP_LIST_HEADERS_B a ,QP_LIST_LINES b, QP_PRICING_ATTRIBUTES c

849: SELECT distinct a.LIST_TYPE_CODE,b.LIST_HEADER_ID,b.LIST_LINE_ID,b.LIST_LINE_TYPE_CODE,
850: b.PRICING_GROUP_SEQUENCE, b.ARITHMETIC_OPERATOR,b.OPERAND,b.AUTOMATIC_FLAG,
851: b.BENEFIT_PRICE_LIST_LINE_ID,b.LIST_PRICE, c.PRODUCT_ATTRIBUTE_CONTEXT,
852: c.PRODUCT_ATTRIBUTE,c.PRODUCT_ATTR_VALUE , b.ACCRUAL_FLAG,b.MODIFIER_LEVEL_CODE
853: FROM QP_LIST_HEADERS_B a ,QP_LIST_LINES b, QP_PRICING_ATTRIBUTES c
854: WHERE a.LIST_HEADER_ID = b.LIST_HEADER_ID
855: AND b.LIST_LINE_ID = c.LIST_LINE_ID
856: AND b.LIST_LINE_ID= p_related_modifier_id;
857: