APPS.GHR_GENERAL dependencies on GHR_REMARKS

Line 27: -- Retrieve remark code from table ghr_remarks.

23: -- ---------------------------------------------------------------------------
24: -- {Start of Comments}
25: --
26: -- Description:
27: -- Retrieve remark code from table ghr_remarks.
28: --
29: -- Prerequisites:
30: -- p_remark_id must be provided.
31: --

Line 50: FUNCTION get_remark_code(p_remark_id IN ghr_remarks.code%type)

46: --
47: -- {End of Comments}
48: -- ---------------------------------------------------------------------------
49: --
50: FUNCTION get_remark_code(p_remark_id IN ghr_remarks.code%type)
51: Return VARCHAR2 AS
52:
53: rem_code ghr_remarks.code%type;
54: cursor c1 (p_remark_id Number) is

Line 53: rem_code ghr_remarks.code%type;

49: --
50: FUNCTION get_remark_code(p_remark_id IN ghr_remarks.code%type)
51: Return VARCHAR2 AS
52:
53: rem_code ghr_remarks.code%type;
54: cursor c1 (p_remark_id Number) is
55: select code from ghr_remarks where remark_id = p_remark_id;
56: BEGIN
57: open c1(p_remark_id);

Line 55: select code from ghr_remarks where remark_id = p_remark_id;

51: Return VARCHAR2 AS
52:
53: rem_code ghr_remarks.code%type;
54: cursor c1 (p_remark_id Number) is
55: select code from ghr_remarks where remark_id = p_remark_id;
56: BEGIN
57: open c1(p_remark_id);
58: fetch c1 into rem_code;
59: close c1;