APPS.GHR_MASS_ACTIONS_PKG dependencies on GHR_REMARKS

Line 69: from ghr_remarks rem

65:
66: Cursor c_rem_desc is
67: select rem.remark_id,
68: rem.description
69: from ghr_remarks rem
70: where rem.code = p_remark_code
71: and rem.enabled_flag = 'Y'
72: and nvl(p_effective_date,sysdate)
73: between rem.date_from and nvl(rem.date_to,nvl(p_effective_date, trunc(sysdate)));