DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on HR_GENERAL

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

2650: CURSOR get_salary_basis(l_date_earned date,
2651: l_assignment_id number) IS
2652: /* using lookup_code to avoid the translation issue*/
2653:
2654: select /*hr_general.decode_lookup('PAY_BASIS',BASES.pay_basis)*/
2655: BASES.pay_basis
2656: , INPUTV.input_value_id
2657: from
2658: per_all_assignments_f ASSIGN

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

3198: -- l_legislation_code VARCHAR2(10);
3199:
3200: CURSOR get_asg_hours_freq(p_date_earned date,
3201: p_assignment_id number)IS
3202: SELECT hr_general.decode_lookup('FREQUENCY', ASSIGN.frequency)
3203: ,ASSIGN.normal_hours
3204: FROM per_all_assignments_f ASSIGN
3205: where date_earned
3206: BETWEEN ASSIGN.effective_start_date