DBA Data[Home] [Help]

APPS.PV_USER_RESP_PVT dependencies on PV_PG_MMBR_TRANSITIONS

Line 3271: FROM pv_pg_mmbr_transitions tran, pv_pg_memberships prev

3267: AND resp_type_code = G_PROGRAM;
3268:
3269: CURSOR c_get_prev_memberships (cv_membership_id NUMBER) IS
3270: SELECT prev.program_id
3271: FROM pv_pg_mmbr_transitions tran, pv_pg_memberships prev
3272: WHERE tran.to_membership_id = cv_membership_id
3273: AND prev.membership_id = tran.from_membership_id;
3274:
3275: l_api_name CONSTANT VARCHAR2(30) := 'manage_active_memb_resp';