APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on PV_PG_MMBR_TRANSITIONS

Line 3859: FROM pv_pg_mmbr_transitions trans,

3855: FROM pv_pg_memberships mmbr
3856: WHERE mmbr.membership_id = cv_membership_id
3857: AND NOT EXISTS
3858: ( SELECT 1
3859: FROM pv_pg_mmbr_transitions trans,
3860: pv_pg_memberships mmbr_future
3861: WHERE trans.from_membership_id = mmbr.membership_id
3862: AND trans.to_membership_id = mmbr_future.membership_id
3863: AND mmbr_future.membership_status_code = 'FUTURE' );

Line 4000: FROM pv_pg_mmbr_transitions trans,

3996: AND notif_rule.active_flag = 'Y'
3997: AND notif_rule.notif_type_code = 'PG_MEM_EXP'
3998: AND NOT EXISTS
3999: ( SELECT 1
4000: FROM pv_pg_mmbr_transitions trans,
4001: pv_pg_memberships mmbr_future
4002: WHERE trans.from_membership_id = mmbr.membership_id
4003: AND trans.to_membership_id = mmbr_future.membership_id
4004: AND mmbr_future.membership_status_code = 'FUTURE'

Line 4201: FROM pv_pg_mmbr_transitions trans,

4197: WHERE mmbr.membership_status_code = 'ACTIVE'
4198: AND trunc(SYSDATE - mmbr.original_end_date) >= 1
4199: AND NOT EXISTS
4200: ( SELECT 1
4201: FROM pv_pg_mmbr_transitions trans,
4202: pv_pg_memberships mmbr_future
4203: WHERE trans.from_membership_id = mmbr.membership_id
4204: AND trans.to_membership_id = mmbr_future.membership_id
4205: AND mmbr_future.membership_status_code = 'FUTURE' ) ;

Line 4222: pv_pg_mmbr_transitions trans

4218: mmbr.object_version_number,
4219: mmbr_future.object_version_number future_memb_obj_ver_no
4220: FROM pv_pg_memberships mmbr,
4221: pv_pg_memberships mmbr_future,
4222: pv_pg_mmbr_transitions trans
4223: WHERE mmbr.membership_status_code = 'ACTIVE'
4224: --AND trunc(SYSDATE - mmbr.original_end_date) >= 1
4225: AND mmbr.original_end_date <= trunc(SYSDATE -1 )
4226: AND trans.from_membership_id = mmbr.membership_id