DBA Data[Home] [Help]

APPS.PV_ENRL_PREREQ_BINS_PUB dependencies on PV_PG_MEMBERSHIPS

Line 131: FROM pv_pg_memberships memb

127: SELECT 1
128: FROM dual
129: WHERE not exists(
130: SELECT 1
131: FROM pv_pg_memberships memb
132: WHERE memb.program_id = c_program_id
133: AND memb.partner_id = c_partner_id
134: AND memb.MEMBERSHIP_STATUS_CODE = 'ACTIVE'
135: AND memb.START_DATE <= SYSDATE