APPS.OZF_OFFER_PVT dependencies on OZF_RELATED_DEAL_LINES

Line 1074: FROM ozf_related_deal_lines a

1070: )
1071: IS
1072: CURSOR c_rltdListLine(cp_listLineId NUMBER) IS
1073: SELECT nvl(related_modifier_id,-1) related_modifier_id
1074: FROM ozf_related_deal_lines a
1075: WHERE a.modifier_id = cp_listLineId;
1076:
1077: CURSOR c_pricingAttrId (cp_listLineId NUMBER, cp_productAttr VARCHAR2, cp_productAttrValue VARCHAR2) IS
1078: SELECT pricing_attribute_id

Line 1408: FROM ozf_related_deal_lines

1404: WHERE qpq.list_line_id = p_list_line_id;
1405:
1406: CURSOR c_rltd_modifier_id(p_qp_list_header_id NUMBER, p_modifier_id NUMBER) IS
1407: SELECT related_modifier_id
1408: FROM ozf_related_deal_lines
1409: WHERE modifier_id = p_modifier_id
1410: AND qp_list_header_id = p_qp_list_header_id;
1411:
1412: l_api_version CONSTANT NUMBER := 1.0;

Line 8075: FROM ozf_related_deal_lines

8071: AND list_line_id = p_list_line_id;
8072:
8073: CURSOR c_modifier_id(l_id NUMBER) IS
8074: SELECT modifier_id, related_modifier_id
8075: FROM ozf_related_deal_lines
8076: WHERE related_deal_lines_id = l_id;
8077:
8078: CURSOR c_creation(l_id NUMBER) IS
8079: SELECT creation_date, created_by

Line 8080: FROM ozf_related_deal_lines

8076: WHERE related_deal_lines_id = l_id;
8077:
8078: CURSOR c_creation(l_id NUMBER) IS
8079: SELECT creation_date, created_by
8080: FROM ozf_related_deal_lines
8081: WHERE related_deal_lines_id = l_id;
8082:
8083: BEGIN
8084: x_return_status := Fnd_Api.g_ret_sts_success;