APPS.PQP_PENSION_FUNCTIONS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 527: FROM per_assignments_f asg,per_assignment_status_types past

523: c_period_start_dt IN DATE,
524: c_period_end_dt IN DATE
525: ) IS
526: SELECT min(asg.effective_start_date) , max(asg.effective_end_date)
527: FROM per_assignments_f asg,per_assignment_status_types past
528: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
529: AND past.per_system_status = 'ACTIVE_ASSIGN'
530: AND asg.effective_start_date <= c_period_end_dt
531: AND nvl(asg.effective_end_date, c_period_end_dt) >= c_period_start_dt

Line 539: FROM per_assignments_f asg,per_assignment_status_types past

535: c_period_start_dt IN DATE
536: ) IS
537: SELECT
538: decode(asg.EFFECTIVE_END_DATE,to_date('31-12-4712','dd-mm-yyyy'),null,asg.EFFECTIVE_END_DATE)
539: FROM per_assignments_f asg,per_assignment_status_types past
540: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
541: AND past.per_system_status = 'ACTIVE_ASSIGN'
542: AND trunc(c_period_start_dt) = asg.effective_start_date
543: AND asg.assignment_id = c_assign_id;

Line 2268: FROM per_assignment_status_types

2264: FROM per_all_assignments_f asg
2265: WHERE assignment_id = p_assignment_id
2266: AND effective_start_date <= l_dt_earned --11670586
2267: AND assignment_status_type_id IN (SELECT assignment_status_type_id
2268: FROM per_assignment_status_types
2269: WHERE per_system_status = 'TERM_ASSIGN'
2270: AND active_flag = 'Y');
2271:
2272: l_asg_term_indicator VARCHAR2(1);

Line 3656: select assignment_status_type_id from per_assignment_status_types typ

3652: where asg.person_id = c_person_id
3653: and asg.assignment_status_type_id in (select assignment_status_type_id from PER_ASS_STATUS_TYPE_AMENDS
3654: where business_group_id = p_business_group_id and pay_system_status = 'P' and active_flag = 'Y'
3655: union
3656: select assignment_status_type_id from per_assignment_status_types typ
3657: where typ.pay_system_status = 'P'
3658: and typ.active_flag = 'Y'
3659: and ( (typ.legislation_code is null and typ.business_group_id is null)
3660: OR (typ.legislation_code is null and

Line 5215: ,per_assignment_status_types past

5211: --
5212: CURSOR c_get_assign_start_date IS
5213: SELECT min(asg.effective_start_date)
5214: FROM per_assignments_f asg
5215: ,per_assignment_status_types past
5216: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
5217: AND past.per_system_status = 'ACTIVE_ASSIGN'
5218: AND asg.effective_start_date <= trunc(p_period_end_date)
5219: AND nvl(asg.effective_end_date, trunc(p_period_end_date)) >= trunc(p_period_start_date)

Line 5235: ,per_assignment_status_types past

5231: trunc(p_period_end_date),
5232: asg.effective_end_date) End_Dt
5233: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
5234: FROM per_assignments_f asg
5235: ,per_assignment_status_types past
5236: ,hr_soft_coding_keyflex target
5237: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
5238: AND past.per_system_status = 'ACTIVE_ASSIGN'
5239: AND asg.effective_end_date >= c_effective_date

Line 5500: ,per_assignment_status_types past

5496: --
5497: CURSOR c_get_assign_start_date IS
5498: SELECT min(asg.effective_start_date)
5499: FROM per_all_assignments_f asg
5500: ,per_assignment_status_types past
5501: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
5502: AND past.per_system_status = 'ACTIVE_ASSIGN'
5503: --AND asg.effective_start_date <= trunc(p_period_start_date)
5504: AND asg.assignment_id = p_assignment_id;