eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_PG_NOTIF_UTILITY_PVT dependencies on PV_GE_NOTIF_RULES_B

Line 3989: pv_ge_notif_rules_b notif_rule

3985: mmbr.enrl_request_id,
3986: mmbr.partner_id,
3987: (notif_rule.repeat_freq_value * DECODE(notif_rule.repeat_freq_unit, 'PV_DAYS',1,'PV_WEEK', 7,'PV_MONTH', 30)) wait_time_in_days
3988: FROM pv_pg_memberships mmbr,
3989: pv_ge_notif_rules_b notif_rule
3990: WHERE mmbr.membership_status_code = 'ACTIVE'
3991: AND trunc(mmbr.original_end_date - sysdate) < notif_rule.send_notif_before_value *
3992: DECODE(notif_rule.send_notif_before_unit, 'PV_DAYS',1,'PV_WEEK', 7,
3993: 'PV_MONTH', 30)

Line 4026: pv_ge_notif_rules_b notif_rule

4022: DECODE(notif_rule.repeat_freq_unit, 'PV_DAYS',1,
4023: 'PV_WEEK', 7,
4024: 'PV_MONTH', 30) "wait_time_in_days"
4025: FROM pv_pg_enrl_requests enrq,
4026: pv_ge_notif_rules_b notif_rule
4027: WHERE enrq.contract_status_code = 'AWAITING_FAX_OR_MAIL'
4028: AND enrq.request_status_code in ('AWAITING_APPROVAL', 'APPROVED')
4029: AND (enrq.request_submission_date -sysdate) < notif_rule.send_notif_after_value *
4030: DECODE(notif_rule.send_notif_after_unit, 'PV_DAYS',1,