APPS.PQP_PENSION_FUNCTIONS dependencies on PER_ASSIGNMENTS_F

Line 485: FROM per_assignments_f asg,per_assignment_status_types past

481: c_period_start_dt IN DATE,
482: c_period_end_dt IN DATE
483: ) IS
484: SELECT min(asg.effective_start_date) , max(asg.effective_end_date)
485: FROM per_assignments_f asg,per_assignment_status_types past
486: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
487: AND past.per_system_status = 'ACTIVE_ASSIGN'
488: AND asg.effective_start_date <= c_period_end_dt
489: AND nvl(asg.effective_end_date, c_period_end_dt) >= c_period_start_dt

Line 497: FROM per_assignments_f asg,per_assignment_status_types past

493: c_period_start_dt IN DATE
494: ) IS
495: SELECT
496: decode(asg.EFFECTIVE_END_DATE,to_date('31-12-4712','dd-mm-yyyy'),null,asg.EFFECTIVE_END_DATE)
497: FROM per_assignments_f asg,per_assignment_status_types past
498: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
499: AND past.per_system_status = 'ACTIVE_ASSIGN'
500: AND trunc(c_period_start_dt) = asg.effective_start_date
501: AND asg.assignment_id = c_assign_id;

Line 529: FROM hr_soft_coding_keyflex hr_keyflex,per_assignments_f ASSIGN

525:
526: CURSOR
527: c_get_max_si_values(c_assignment_id IN NUMBER,c_effective_date IN DATE) IS
528: SELECT SEGMENT26,segment27
529: FROM hr_soft_coding_keyflex hr_keyflex,per_assignments_f ASSIGN
530: WHERE ASSIGN.assignment_id = c_assignment_id
531: AND hr_keyflex.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id
532: AND hr_keyflex.enabled_flag = 'Y'
533: AND trunc(c_effective_date) BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date;

Line 2034: FROM per_assignments_f asg

2030: AND date_start <= p_date_earned;
2031:
2032: CURSOR c_pt_cur (c_effective_date IN DATE) IS
2033: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
2034: FROM per_assignments_f asg
2035: ,hr_soft_coding_keyflex target
2036: WHERE asg.assignment_id = p_assignment_id
2037: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
2038: AND trunc(c_effective_date) between asg.effective_start_date

Line 5117: FROM per_assignments_f asg

5113: -- Cursor to get the start date for the active asg
5114: --
5115: CURSOR c_get_assign_start_date IS
5116: SELECT min(asg.effective_start_date)
5117: FROM per_assignments_f asg
5118: ,per_assignment_status_types past
5119: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
5120: AND past.per_system_status = 'ACTIVE_ASSIGN'
5121: AND asg.effective_start_date <= trunc(p_period_end_date)

Line 5137: FROM per_assignments_f asg

5133: to_date ('31/12/4712','DD/MM/YYYY'),
5134: trunc(p_period_end_date),
5135: asg.effective_end_date) End_Dt
5136: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
5137: FROM per_assignments_f asg
5138: ,per_assignment_status_types past
5139: ,hr_soft_coding_keyflex target
5140: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
5141: AND past.per_system_status = 'ACTIVE_ASSIGN'