APPS.PV_PARTNER_TREND_PVT dependencies on PV_ENTITY_ATTRS

Line 134: from pv_entity_attrs a, pv_attributes_b b, pv_attributes_tl c

130: -nvl(a.last_refresh_date,sysdate),
131: 'MONTH', add_months(trunc(NVL(a.last_refresh_date,SYSDATE), 'MM'), a.refresh_frequency)
132: -nvl(a.last_refresh_date,sysdate)
133: ),0) refresh_interval_days
134: from pv_entity_attrs a, pv_attributes_b b, pv_attributes_tl c
135: where a.entity = 'PARTNER_TREND'
136: and a.attribute_id = b.attribute_id
137: and a.enabled_flag = 'Y' and b.performance_flag = 'Y'
138: and b.enabled_flag = 'Y'

Line 331: and attribute_id in ( select b.attribute_id from pv_entity_attrs a, pv_attributes_b b

327: begin
328: savepoint current_partner;
329: delete from pv_entity_attr_trends where entity = 'PARTNER' and time_uom = 'MONTH'
330: and entity_id = l_new_pt_rec.partner_id
331: and attribute_id in ( select b.attribute_id from pv_entity_attrs a, pv_attributes_b b
332: where a.entity = 'PARTNER_TREND' and a.attribute_id = b.attribute_id
333: and b.performance_flag = 'Y' and b.additive_flag = 'Y')
334: and trend_timeline between l_from_date and l_to_date;
335:

Line 337: and attribute_id in ( select b.attribute_id from pv_entity_attrs a, pv_attributes_b b

333: and b.performance_flag = 'Y' and b.additive_flag = 'Y')
334: and trend_timeline between l_from_date and l_to_date;
335:
336: delete from pv_entity_attr_trends where entity = 'PARTNER' and time_uom = 'MONTH'
337: and attribute_id in ( select b.attribute_id from pv_entity_attrs a, pv_attributes_b b
338: where a.entity = 'PARTNER_TREND' and a.attribute_id = b.attribute_id
339: and b.performance_flag = 'Y' and b.additive_flag = 'N')
340: and entity_id = l_new_pt_rec.partner_id and trend_timeline = trunc(l_run_date, 'MM');
341:

Line 521: update pv_entity_attrs set last_refresh_date = l_run_date where attribute_id = lc_attr_rec.attribute_id

517: lc_attr_rec.attribute_id, l_result_tbl(i), l_currency_code, l_currency_date, l_month_tbl(i), 'MONTH');
518: end if;
519:
520: if l_attr_has_data then
521: update pv_entity_attrs set last_refresh_date = l_run_date where attribute_id = lc_attr_rec.attribute_id
522: and entity = 'PARTNER_TREND';
523: else
524: Debug('Attribute: ' || lc_attr_rec.name || ' has no data for any partner for time period specified');
525: end if;