1068:
1069:
1070: Cursor csr_gl_currency(p_gl_id IN NUMBER, p_effective_date IN DATE) IS
1071: SELECT pgm_uom
1072: FROM ben_pgm_f
1073: WHERE pgm_id = p_gl_id
1074: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1075:
1076: l_gl_currency ben_pgm_f.pgm_uom%TYPE;
1072: FROM ben_pgm_f
1073: WHERE pgm_id = p_gl_id
1074: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1075:
1076: l_gl_currency ben_pgm_f.pgm_uom%TYPE;
1077: l_step_rate NUMBER(30,5);
1078:
1079: l_asg_salary NUMBER(30,5);
1080: BEGIN