DBA Data[Home] [Help]

APPS.PAY_US_INV_DED_FORMULAS dependencies on HR_GENERAL

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

2987: v_to_annualizing_factor NUMBER(30,7);
2988:
2989: CURSOR get_asg_hours_freq(cp_date_earned date,
2990: cp_assignment_id number) IS
2991: SELECT hr_general.decode_lookup('FREQUENCY', ASSIGN.frequency)
2992: ,ASSIGN.normal_hours
2993: FROM per_all_assignments_f ASSIGN
2994: where cp_date_earned BETWEEN ASSIGN.effective_start_date
2995: AND ASSIGN.effective_end_date