APPS.PQP_PENSION_FUNCTIONS dependencies on PER_ASSIGNMENT_STATUS_TYPES

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 2201: FROM per_assignment_status_types

2197: FROM per_all_assignments_f asg
2198: WHERE assignment_id = p_assignment_id
2199: AND effective_start_date <= p_date_earned
2200: AND assignment_status_type_id IN (SELECT assignment_status_type_id
2201: FROM per_assignment_status_types
2202: WHERE per_system_status = 'TERM_ASSIGN'
2203: AND active_flag = 'Y');
2204:
2205: l_asg_term_indicator VARCHAR2(1);

Line 3559: select assignment_status_type_id from per_assignment_status_types typ

3555: where asg.person_id = c_person_id
3556: and asg.assignment_status_type_id in (select assignment_status_type_id from PER_ASS_STATUS_TYPE_AMENDS
3557: where business_group_id = p_business_group_id and pay_system_status = 'P' and active_flag = 'Y'
3558: union
3559: select assignment_status_type_id from per_assignment_status_types typ
3560: where typ.pay_system_status = 'P'
3561: and typ.active_flag = 'Y'
3562: and ( (typ.legislation_code is null and typ.business_group_id is null)
3563: OR (typ.legislation_code is null and

Line 5118: ,per_assignment_status_types past

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)
5122: AND nvl(asg.effective_end_date, trunc(p_period_end_date)) >= trunc(p_period_start_date)

Line 5138: ,per_assignment_status_types past

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'
5142: AND asg.effective_end_date >= c_effective_date

Line 5403: ,per_assignment_status_types past

5399: --
5400: CURSOR c_get_assign_start_date IS
5401: SELECT min(asg.effective_start_date)
5402: FROM per_all_assignments_f asg
5403: ,per_assignment_status_types past
5404: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
5405: AND past.per_system_status = 'ACTIVE_ASSIGN'
5406: --AND asg.effective_start_date <= trunc(p_period_start_date)
5407: AND asg.assignment_id = p_assignment_id;