DBA Data[Home] [Help]

APPS.PV_USER_MGMT_PVT dependencies on PV_PG_MEMBERSHIPS

Line 2279: FROM pv_pg_memberships memb

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