DBA Data[Home] [Help]

APPS.PV_USER_MGMT_PVT dependencies on PV_PG_MEMBERSHIPS

Line 2282: FROM pv_pg_memberships memb

2278: SELECT 1
2279: FROM dual
2280: WHERE not exists(
2281: SELECT 1
2282: FROM pv_pg_memberships memb
2283: WHERE memb.program_id = c_program_id
2284: AND memb.partner_id = c_partner_id
2285: AND memb.MEMBERSHIP_STATUS_CODE = 'ACTIVE'
2286: AND memb.START_DATE <= SYSDATE