APPS.OZF_OFFER_PUB dependencies on OZF_XREF_MAP

Line 1936: FROM qp_list_lines line, ozf_xref_map map

1932:
1933: CURSOR c_list_line(p_list_header_id IN NUMBER) IS
1934: SELECT NVL(map.xref_line_id_value,line.list_line_id) list_line_id
1935: , NVL(map.list_line_number,list_line_no) list_line_no
1936: FROM qp_list_lines line, ozf_xref_map map
1937: WHERE list_header_id = p_list_header_id
1938: AND line.list_line_id = map.list_line_id(+);
1939:
1940: CURSOR c_lump_line(p_list_header_id IN NUMBER) IS

Line 1943: FROM ams_act_products prod, ozf_xref_map map

1939:
1940: CURSOR c_lump_line(p_list_header_id IN NUMBER) IS
1941: SELECT NVL(map.xref_line_id_value,prod.activity_product_id) activity_product_id
1942: ,NVL(map.list_line_number,prod.attribute1) attribute1
1943: FROM ams_act_products prod, ozf_xref_map map
1944: WHERE act_product_used_by_id = p_list_header_id
1945: AND arc_act_product_used_by = 'OFFR'
1946: AND prod.activity_product_id = map.list_line_id(+);
1947:

Line 2402: INSERT INTO ozf_xref_map ( map_attr_id

2398: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
2399: RAISE Fnd_Api.g_exc_unexpected_error;
2400: END IF;
2401: --//Fix for bug 13717016
2402: INSERT INTO ozf_xref_map ( map_attr_id
2403: , list_line_id
2404: , list_line_number
2405: , xref_line_id_value
2406: , xref_line_number_value

Line 2533: INSERT INTO ozf_xref_map ( map_attr_id

2529: FOR list_line_rec IN c_list_line(x_qp_list_header_id) LOOP
2530: x_line_tbl(k).list_line_number := list_line_rec.list_line_no;
2531: x_line_tbl(k).list_line_id := TO_NUMBER(list_line_rec.list_line_id||'.'||'1');
2532:
2533: INSERT INTO ozf_xref_map ( map_attr_id
2534: , list_line_id
2535: , list_line_number
2536: , xref_line_id_value
2537: , xref_line_number_value