APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_REMARKS

Line 269: p_remark_id IN ghr_remarks.remark_id%TYPE)

265:
266: END get_noa_descriptor;
267:
268: FUNCTION get_remark_descriptor(
269: p_remark_id IN ghr_remarks.remark_id%TYPE)
270: RETURN VARCHAR2 IS
271:
272: l_ret_val ghr_remarks.description%TYPE := NULL;
273:

Line 272: l_ret_val ghr_remarks.description%TYPE := NULL;

268: FUNCTION get_remark_descriptor(
269: p_remark_id IN ghr_remarks.remark_id%TYPE)
270: RETURN VARCHAR2 IS
271:
272: l_ret_val ghr_remarks.description%TYPE := NULL;
273:
274: CURSOR cur_rem IS
275: SELECT rem.description
276: FROM ghr_remarks rem

Line 276: FROM ghr_remarks rem

272: l_ret_val ghr_remarks.description%TYPE := NULL;
273:
274: CURSOR cur_rem IS
275: SELECT rem.description
276: FROM ghr_remarks rem
277: WHERE rem.remark_id = p_remark_id;
278:
279: BEGIN
280: FOR cur_rem_rec IN cur_rem LOOP