2438: )
2439: IS
2440: l_eq_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2441: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2442: l_remark_id1 ghr_remarks.remark_id%TYPE;
2443: l_remark_code1 ghr_remarks.code%TYPE := NULL;
2444: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
2445: l_remark_desc1_out ghr_pa_remarks.description%TYPE;
2446: l_remark_code2 ghr_remarks.code%TYPE := NULL;
2439: IS
2440: l_eq_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2441: l_from_pay_plan ghr_pa_requests.from_pay_plan%TYPE;
2442: l_remark_id1 ghr_remarks.remark_id%TYPE;
2443: l_remark_code1 ghr_remarks.code%TYPE := NULL;
2444: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
2445: l_remark_desc1_out ghr_pa_remarks.description%TYPE;
2446: l_remark_code2 ghr_remarks.code%TYPE := NULL;
2447: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;
2442: l_remark_id1 ghr_remarks.remark_id%TYPE;
2443: l_remark_code1 ghr_remarks.code%TYPE := NULL;
2444: l_remark_desc1 ghr_pa_remarks.description%TYPE := NULL;
2445: l_remark_desc1_out ghr_pa_remarks.description%TYPE;
2446: l_remark_code2 ghr_remarks.code%TYPE := NULL;
2447: l_remark_desc2 ghr_pa_remarks.description%TYPE := NULL;
2448: l_remark_desc2_out ghr_pa_remarks.description%TYPE;
2449: l_remark1_ins1 VARCHAR2 (150) := NULL;
2450: l_remark1_ins2 VARCHAR2 (150) := NULL;