APPS.PAY_CALC_HOURS_WORKED dependencies on HR_GENERAL

Line 158: SELECT hr_general.decode_lookup('FREQUENCY', ASSIGN.frequency)

154: lv_wk_sch_found VARCHAR2(20);
155:
156: CURSOR get_asg_hours_freq(p_date_earned date,
157: p_assignment_id number)IS
158: SELECT hr_general.decode_lookup('FREQUENCY', ASSIGN.frequency)
159: ,ASSIGN.normal_hours
160: FROM per_all_assignments_f ASSIGN
161: where date_earned
162: BETWEEN ASSIGN.effective_start_date