[Home] [Help]
151: p_assignment_id number) IS
152: SELECT target.SEGMENT4
153: FROM /* route for SCL keyflex - assignment level */
154: hr_soft_coding_keyflex target,
155: per_all_assignments_f ASSIGN
156: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
157: AND ASSIGN.effective_end_date
158: AND ASSIGN.assignment_id = p_assignment_id
159: AND target.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id
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
412: AND ASSIGN.effective_end_date
413: and ASSIGN.assignment_id = cp_assignment_id
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
3068: , per_pay_bases BASES
3069: , pay_input_values_f INPUTV
3070: , pay_element_types_f ETYPE
3071: , pay_rates RATE
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
3617: AND ASSIGN.effective_end_date
3618: and ASSIGN.assignment_id = p_assignment_id;
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
4020: AND ASSIGN.effective_end_date
4021: and ASSIGN.assignment_id = p_assignment_id;