DBA Data[Home] [Help]

APPS.PV_PARTNER_TREND_PVT dependencies on PV_PARTNER_PROFILES

Line 148: FROM pv_partner_profiles pvpp

144: -- predicate.
145: -- ---------------------------------------------------------------------------------
146: cursor lc_get_new_pt (pc_creation_date date, pc_partner_id number) is
147: SELECT partner_id
148: FROM pv_partner_profiles pvpp
149: WHERE pvpp.status = 'A' AND
150: pvpp.partner_resource_id IS NOT NULL AND
151: pvpp.creation_date >= pc_creation_date
152: union all

Line 153: select partner_id from pv_partner_profiles pvpp

149: WHERE pvpp.status = 'A' AND
150: pvpp.partner_resource_id IS NOT NULL AND
151: pvpp.creation_date >= pc_creation_date
152: union all
153: select partner_id from pv_partner_profiles pvpp
154: where status = 'A' AND
155: pvpp.partner_resource_id IS NOT NULL AND
156: partner_id = pc_partner_id;
157: