APPS.OZF_OFFER_PVT dependencies on OZF_RELATED_DEAL_LINES

Line 977: FROM ozf_related_deal_lines a

973: )
974: IS
975: CURSOR c_rltdListLine(cp_listLineId NUMBER) IS
976: SELECT nvl(related_modifier_id,-1) related_modifier_id
977: FROM ozf_related_deal_lines a
978: WHERE a.modifier_id = cp_listLineId;
979:
980: CURSOR c_pricingAttrId (cp_listLineId NUMBER, cp_productAttr VARCHAR2, cp_productAttrValue VARCHAR2) IS
981: SELECT pricing_attribute_id

Line 1307: FROM ozf_related_deal_lines

1303: WHERE qpq.list_line_id = p_list_line_id;
1304:
1305: CURSOR c_rltd_modifier_id(p_qp_list_header_id NUMBER, p_modifier_id NUMBER) IS
1306: SELECT related_modifier_id
1307: FROM ozf_related_deal_lines
1308: WHERE modifier_id = p_modifier_id
1309: AND qp_list_header_id = p_qp_list_header_id;
1310:
1311: l_api_version CONSTANT NUMBER := 1.0;

Line 7541: FROM ozf_related_deal_lines

7537: AND list_line_id = p_list_line_id;
7538:
7539: CURSOR c_modifier_id(l_id NUMBER) IS
7540: SELECT modifier_id, related_modifier_id
7541: FROM ozf_related_deal_lines
7542: WHERE related_deal_lines_id = l_id;
7543:
7544: CURSOR c_creation(l_id NUMBER) IS
7545: SELECT creation_date, created_by

Line 7546: FROM ozf_related_deal_lines

7542: WHERE related_deal_lines_id = l_id;
7543:
7544: CURSOR c_creation(l_id NUMBER) IS
7545: SELECT creation_date, created_by
7546: FROM ozf_related_deal_lines
7547: WHERE related_deal_lines_id = l_id;
7548:
7549: BEGIN
7550: x_return_status := Fnd_Api.g_ret_sts_success;