[Home] [Help]
742: ,fnd_number.canonical_to_number (nvl (target.segment29
743: ,'100')) ptp
744: FROM per_assignments_f asg
745: ,per_assignment_status_types past
746: ,hr_soft_coding_keyflex target
747: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
748: AND past.per_system_status = 'ACTIVE_ASSIGN'
749: AND asg.effective_end_date >= c_effective_date
750: AND asg.assignment_id = c_assignment_id
1197: ,asg.effective_end_date end_date
1198: ,least(fnd_number.canonical_to_number (nvl (target.segment29
1199: ,'100')),125) ptp
1200: FROM per_assignments_f asg
1201: ,hr_soft_coding_keyflex target
1202: WHERE asg.assignment_id = c_asg_id
1203: AND asg.effective_start_date BETWEEN c_start_date
1204: AND nvl (c_end_date
1205: ,hr_general.end_of_time)
1245: SELECT least (fnd_number.canonical_to_number (nvl (target.segment29
1246: ,'100'))
1247: ,125) ptp
1248: FROM per_assignments_f asg
1249: ,hr_soft_coding_keyflex target
1250: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1251: AND asg.assignment_id = c_asg_id
1252: AND target.enabled_flag = 'Y'
1253: AND trunc (c_effective_date) BETWEEN asg.effective_start_date
1257: ,c_asg_id IN NUMBER) IS
1258: SELECT nvl (hourly_salaried_code
1259: ,'H') hourly_salaried_code
1260: FROM per_assignments_f asg
1261: ,hr_soft_coding_keyflex target
1262: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1263: AND asg.assignment_id = c_asg_id
1264: AND target.enabled_flag = 'Y'
1265: AND trunc (c_effective_date) BETWEEN asg.effective_start_date
3010: -- Income Code
3011: CURSOR csr_income_code(c_assignment_id IN NUMBER
3012: ,c_effective_date IN DATE) IS
3013: SELECT hscf.segment8
3014: FROM hr_soft_coding_keyflex hscf
3015: ,per_all_assignments_f paaf
3016: WHERE paaf.assignment_id = c_assignment_id
3017: AND c_effective_date BETWEEN paaf.effective_start_date
3018: AND paaf.effective_end_date