APPS.PAY_CALC_HOURS_WORKED dependencies on HR_GENERAL

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

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