APPS.GHR_SF52_UPDATE dependencies on GHR_REMARKS

Line 27: GHR_REMARKS grem

23: is
24: CURSOR c1(p_remark_code in varchar2) is
25: SELECT 1
26: FROM GHR_PA_REMARKS parem,
27: GHR_REMARKS grem
28: WHERE parem.remark_id = grem.remark_id
29: AND grem.code = p_remark_code
30: AND parem.pa_request_id = p_pa_request_id;
31:

Line 34: FROM GHR_REMARKS

30: AND parem.pa_request_id = p_pa_request_id;
31:
32: CURSOR C2(p_remark_code in varchar2) is
33: SELECT *
34: FROM GHR_REMARKS
35: WHERE code = p_remark_code
36: and p_effective_date between date_from and nvl(date_to,p_effective_date);
37:
38: CURSOR C3 is

Line 75: l_description ghr_remarks.description%type;

71: l_found varchar2(1);
72: l_remark c2%rowtype;
73: l_pa_remark_id ghr_pa_remarks.pa_remark_id%type;
74: l_object_version_number ghr_pa_remarks.object_version_number%type;
75: l_description ghr_remarks.description%type;
76: l_user_table_name pay_user_tables.user_table_name%type;
77: l_retained_grade_info ghr_pay_calc.retained_grade_rec_type;
78: l_retained_grade varchar2(10);
79: -- Bug # 7269520