DBA Data[Home] [Help]

APPS.PV_PARTNER_TREND_PVT dependencies on PV_ATTRIBUTES_TL

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'