DBA Data[Home] [Help]

APPS.PAY_CORE_FF_UDFS dependencies on PER_ALL_ASSIGNMENTS_F

Line 2658: per_all_assignments_f ASSIGN

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
2659: , per_pay_bases BASES
2660: , pay_input_values_f INPUTV
2661: , pay_element_types_f ETYPE
2662: , pay_rates RATE

Line 3204: FROM per_all_assignments_f ASSIGN

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
3207: AND ASSIGN.effective_end_date
3208: and ASSIGN.assignment_id = p_assignment_id;