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_BENFT_STATUS_CHANGE dependencies on PV_GE_HISTORY_LOG_VL

Line 539: FROM pv_ge_history_log_vl

535: -- Before check for anything, check if the referral had been approved
536: -- at some point in time.
537: -- --------------------------------------------------------------------
538: FOR x IN (SELECT COUNT(*) approved_count
539: FROM pv_ge_history_log_vl
540: WHERE ARC_HISTORY_FOR_ENTITY_CODE = 'PVREFFRL' AND
541: history_for_entity_id = p_entity_id AND
542: message_code IN ('PV_LG_REF_APPROVED',
543: 'PV_LG_REF_APPROVED_DUP_OPPTY',

Line 687: FROM pv_ge_history_log_vl

683: -- Before check for anything, check if the referral had been approved
684: -- at some point in time.
685: -- --------------------------------------------------------------------
686: FOR x IN (SELECT COUNT(*) approved_count
687: FROM pv_ge_history_log_vl
688: WHERE ARC_HISTORY_FOR_ENTITY_CODE = 'PVDEALRN' AND
689: history_for_entity_id = p_entity_id AND
690: message_code IN ('PV_LG_DEAL_APPROVED',
691: 'PV_LG_DEAL_APPROVED_DUP_DEAL',