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 1608: pv_attributes_vl b

1604: -- ----------------------------------------------------------------------
1605: CURSOR c_currency_attrs IS
1606: SELECT a.attribute_id, b.name
1607: FROM pv_entity_attrs a,
1608: pv_attributes_vl b
1609: WHERE b.attribute_id <> 1 AND
1610: a.attribute_id = b.attribute_id AND
1611: a.enabled_flag = 'Y' AND
1612: b.enabled_flag = 'Y' AND

Line 2315: pv_attributes_vl b

2311: CURSOR c_num_cur_attributes IS
2312: SELECT a.attribute_id, a.batch_sql_text, b.name, b.return_type,
2313: b.performance_flag
2314: FROM pv_entity_attrs a,
2315: pv_attributes_vl b
2316: WHERE b.attribute_id <> 1 AND
2317: a.attribute_id = b.attribute_id AND
2318: a.enabled_flag = 'Y' AND
2319: b.enabled_flag = 'Y' AND

Line 2334: pv_attributes_vl b

2330: CURSOR c_other_attributes IS
2331: SELECT a.attribute_id, a.batch_sql_text, b.name, b.return_type,
2332: b.performance_flag
2333: FROM pv_entity_attrs a,
2334: pv_attributes_vl b
2335: WHERE b.attribute_id <> 1 AND
2336: a.attribute_id = b.attribute_id AND
2337: a.enabled_flag = 'Y' AND
2338: b.enabled_flag = 'Y' AND

Line 2886: pv_attributes_vl b

2882: CURSOR lc_template IS
2883: SELECT b.attribute_id, b.performance_flag, b.attribute_type,
2884: a.sql_text, b.name, b.return_type
2885: FROM pv_entity_attrs a,
2886: pv_attributes_vl b
2887: WHERE a.attribute_id = b.attribute_id;
2888:
2889: x lc_template%ROWTYPE;
2890:

Line 2918: pv_attributes_vl b

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

Line 2938: pv_attributes_vl b

2934: OPEN c_func_perf_attrs FOR
2935: SELECT b.attribute_id, b.performance_flag, b.attribute_type,
2936: a.sql_text, b.name, b.return_type
2937: FROM pv_entity_attrs a,
2938: pv_attributes_vl b
2939: WHERE a.attribute_id = b.attribute_id AND
2940: a.entity = 'PARTNER' AND
2941: a.enabled_flag = 'Y' AND
2942: b.enabled_flag = 'Y' AND