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