APPS.OZF_FUND_ALLOCATIONS_PVT dependencies on OZF_TERR_V

Line 83: FROM ozf_terr_v

79:
80: -- cursors for territory
81: CURSOR c_get_terr_name IS
82: SELECT node_value, parent_id
83: FROM ozf_terr_v
84: WHERE hierarchy_id = p_hierarchy_id
85: AND node_id = p_node_id;
86:
87: --R12 - Modified for Primary Contact - bug 4643041

Line 172: FROM ozf_terr_v

168:
169: -- cursors for territory
170: CURSOR c_get_terr_child IS
171: SELECT node_id
172: FROM ozf_terr_v
173: WHERE hierarchy_id = p_hierarchy_id
174: AND parent_id = p_node_id
175: -- Bug # 5723438 fixed by ateotia (+)
176: AND decode(end_date_active,'',sysdate,end_date_active) > = sysdate;

Line 324: ozf_terr_v terr

320: CURSOR c_get_terr_rollup_accts (p_node_id IN NUMBER)
321: IS
322: SELECT DISTINCT pms.cust_account_id
323: FROM ams_party_market_segments pms,
324: ozf_terr_v terr
325: WHERE pms.market_qualifier_type = 'TERRITORY'
326: AND pms.market_qualifier_reference = terr.node_id
327: AND terr.parent_id = ( SELECT terr1.parent_id
328: FROM ozf_terr_v terr1

Line 328: FROM ozf_terr_v terr1

324: ozf_terr_v terr
325: WHERE pms.market_qualifier_type = 'TERRITORY'
326: AND pms.market_qualifier_reference = terr.node_id
327: AND terr.parent_id = ( SELECT terr1.parent_id
328: FROM ozf_terr_v terr1
329: WHERE terr1.node_id = p_node_id);
330:
331: CURSOR c_get_year_to_date_sales( p_as_of_date IN DATE ,
332: p_cust_account_id IN NUMBER)

Line 932: AND NOT EXISTS (SELECT 1 FROM ozf_terr_v WHERE hierarchy_id = p_hierarchy_id AND node_id = seg.market_segment_id))

928: WHERE arc_act_market_segment_used_by = 'FUND'
929: AND act_market_segment_used_by_id = p_fund_id
930: AND (segment_type <> 'TERRITORY'
931: OR (segment_type = 'TERRITORY'
932: AND NOT EXISTS (SELECT 1 FROM ozf_terr_v WHERE hierarchy_id = p_hierarchy_id AND node_id = seg.market_segment_id))
933: );
934:
935: BEGIN
936: SAVEPOINT create_budget_for_one_node_sp;