APPS.PV_CONTEXT_VALUES dependencies on PV_ATTRIBUTES_VL

Line 208: pv_attributes_vl a

204:
205: CURSOR c_attribute1_refresh IS
206: SELECT COUNT(*) count
207: FROM pv_entity_attrs b,
208: pv_attributes_vl a
209: WHERE a.attribute_id = 1 AND
210: a.attribute_id = b.attribute_id AND
211: b.entity = 'PARTNER' AND
212: a.enabled_flag = 'Y' AND

Line 618: pv_attributes_vl b

614: -- ------------------------------------------------------------------
615: IF (l_refresh_type <> g_incr_refresh) THEN
616: FOR x IN (SELECT COUNT(*) count
617: FROM pv_entity_attrs a,
618: pv_attributes_vl b
619: WHERE a.attribute_id = b.attribute_id AND
620: a.entity = 'PARTNER' AND
621: a.enabled_flag = 'Y' AND
622: b.enabled_flag = 'Y' AND

Line 688: pv_attributes_vl b

684:
685: IF (l_refresh_type <> g_incr_refresh) THEN
686: FOR x IN (SELECT a.attribute_id
687: FROM pv_entity_attrs a,
688: pv_attributes_vl b
689: WHERE a.attribute_id = b.attribute_id AND
690: a.entity = 'PARTNER' AND
691: a.enabled_flag = 'Y' AND
692: b.enabled_flag = 'Y' AND

Line 1586: pv_attributes_vl b

1582: -- ----------------------------------------------------------------------
1583: CURSOR c_currency_attrs IS
1584: SELECT a.attribute_id, b.name
1585: FROM pv_entity_attrs a,
1586: pv_attributes_vl b
1587: WHERE b.attribute_id <> 1 AND
1588: a.attribute_id = b.attribute_id AND
1589: a.enabled_flag = 'Y' AND
1590: b.enabled_flag = 'Y' AND

Line 2293: pv_attributes_vl b

2289: CURSOR c_num_cur_attributes IS
2290: SELECT a.attribute_id, a.batch_sql_text, b.name, b.return_type,
2291: b.performance_flag
2292: FROM pv_entity_attrs a,
2293: pv_attributes_vl b
2294: WHERE b.attribute_id <> 1 AND
2295: a.attribute_id = b.attribute_id AND
2296: a.enabled_flag = 'Y' AND
2297: b.enabled_flag = 'Y' AND

Line 2312: pv_attributes_vl b

2308: CURSOR c_other_attributes IS
2309: SELECT a.attribute_id, a.batch_sql_text, b.name, b.return_type,
2310: b.performance_flag
2311: FROM pv_entity_attrs a,
2312: pv_attributes_vl b
2313: WHERE b.attribute_id <> 1 AND
2314: a.attribute_id = b.attribute_id AND
2315: a.enabled_flag = 'Y' AND
2316: b.enabled_flag = 'Y' AND

Line 2864: pv_attributes_vl b

2860: CURSOR lc_template IS
2861: SELECT b.attribute_id, b.performance_flag, b.attribute_type,
2862: a.sql_text, b.name, b.return_type
2863: FROM pv_entity_attrs a,
2864: pv_attributes_vl b
2865: WHERE a.attribute_id = b.attribute_id;
2866:
2867: x lc_template%ROWTYPE;
2868:

Line 2896: pv_attributes_vl b

2892: OPEN c_func_perf_attrs FOR
2893: SELECT b.attribute_id, b.performance_flag, b.attribute_type,
2894: a.sql_text, b.name, b.return_type
2895: FROM pv_entity_attrs a,
2896: pv_attributes_vl b
2897: WHERE a.attribute_id = b.attribute_id AND
2898: a.entity = 'PARTNER' AND
2899: a.enabled_flag = 'Y' AND
2900: b.enabled_flag = 'Y' AND

Line 2916: pv_attributes_vl b

2912: OPEN c_func_perf_attrs FOR
2913: SELECT b.attribute_id, b.performance_flag, b.attribute_type,
2914: a.sql_text, b.name, b.return_type
2915: FROM pv_entity_attrs a,
2916: pv_attributes_vl b
2917: WHERE a.attribute_id = b.attribute_id AND
2918: a.entity = 'PARTNER' AND
2919: a.enabled_flag = 'Y' AND
2920: b.enabled_flag = 'Y' AND