APPS.OZF_FUNDS_PUB dependencies on OZF_XREF_MAP

Line 2805: ozf_xref_map map

2801: SELECT NVL(map.xref_line_id_value,line.list_line_id) list_line_id ,
2802: list_line_no
2803: FROM qp_list_lines line,
2804: ozf_funds_all_b,
2805: ozf_xref_map map
2806: WHERE fund_id = p_fund_id
2807: AND list_header_id = plan_id
2808: AND line.list_line_id = map.list_line_id(+);
2809:

Line 2834: FROM ozf_xref_map

2830: --//Fix for Bug 13654821
2831: CURSOR c_line_id_chk(p_list_line_id NUMBER)
2832: IS
2833: SELECT list_line_id
2834: FROM ozf_xref_map
2835: WHERE xref_line_id_value = p_list_line_id;
2836:
2837: CURSOR c_ledger_from_cat IS
2838: SELECT ledger_id

Line 3568: INSERT INTO ozf_xref_map ( map_attr_id

3564: x_line_tbl(k).list_line_number := list_line_rec.list_line_no;
3565: -- x_line_tbl(k).list_line_id := list_line_rec.list_line_id;
3566: x_line_tbl(k).list_line_id := TO_NUMBER(list_line_rec.list_line_id||'.'||'3');
3567:
3568: INSERT INTO ozf_xref_map ( map_attr_id
3569: , list_line_id
3570: , list_line_number
3571: , xref_line_id_value
3572: , xref_line_number_value

Line 3884: INSERT INTO ozf_xref_map ( map_attr_id

3880:
3881: x_line_tbl(k).list_line_number := list_line_rec.list_line_no;
3882: x_line_tbl(k).list_line_id := TO_NUMBER(list_line_rec.list_line_id||'.'||'3');
3883:
3884: INSERT INTO ozf_xref_map ( map_attr_id
3885: , list_line_id
3886: , list_line_number
3887: , xref_line_id_value
3888: , xref_line_number_value