APPS.PAY_CORE_FF_UDFS dependencies on HR_GENERAL

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

403: and pec.business_group_id IS NULL;
404:
405: CURSOR get_asg_hours_freq(cp_date_earned date,
406: cp_assignment_id number) IS
407: SELECT hr_general.decode_lookup('FREQUENCY', ASSIGN.frequency)
408: ,ASSIGN.normal_hours
409: FROM per_all_assignments_f ASSIGN
410: where cp_date_earned
411: BETWEEN ASSIGN.effective_start_date

Line 3063: select /*hr_general.decode_lookup('PAY_BASIS',BASES.pay_basis)*/

3059: CURSOR get_salary_basis(l_date_earned date,
3060: l_assignment_id number) IS
3061: /* using lookup_code to avoid the translation issue*/
3062:
3063: select /*hr_general.decode_lookup('PAY_BASIS',BASES.pay_basis)*/
3064: BASES.pay_basis
3065: , INPUTV.input_value_id
3066: from
3067: per_all_assignments_f ASSIGN

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

3608: lv_wk_sch_found VARCHAR2(20);
3609:
3610: CURSOR get_asg_hours_freq(p_date_earned date,
3611: p_assignment_id number)IS
3612: SELECT hr_general.decode_lookup('FREQUENCY', ASSIGN.frequency)
3613: ,ASSIGN.normal_hours
3614: FROM per_all_assignments_f ASSIGN
3615: where date_earned
3616: BETWEEN ASSIGN.effective_start_date

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

4011: lv_wk_sch_found VARCHAR2(20);
4012:
4013: CURSOR get_asg_hours_freq(p_date_earned date,
4014: p_assignment_id number)IS
4015: SELECT hr_general.decode_lookup('FREQUENCY', ASSIGN.frequency)
4016: ,ASSIGN.normal_hours
4017: FROM per_all_assignments_f ASSIGN
4018: where date_earned
4019: BETWEEN ASSIGN.effective_start_date