DBA Data[Home] [Help]

APPS.PQH_FR_UTILITY dependencies on BEN_PGM_F

Line 1072: FROM ben_pgm_f

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;

Line 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