[Home] [Help]
674: CURSOR get_asg_active_range(p_asg_id NUMBER, p_tax_ref VARCHAR2) IS
675: SELECT min(paaf.effective_start_date) min_active,
676: max(paaf.effective_end_date) max_active
677: FROM per_all_assignments_f paaf,
678: per_assignment_status_types past,
679: pay_all_payrolls_f papf,
680: hr_soft_coding_keyflex flex
681: WHERE paaf.assignment_id = p_asg_id
682: AND paaf.assignment_status_type_id = past.assignment_status_type_id
3268: trim(pap.per_information10) per_agg_flag,
3269: pap.person_id
3270: from per_all_people_f pap,
3271: per_all_assignments_f paaf,
3272: per_assignment_status_types past,
3273: pay_all_payrolls_f papf,
3274: hr_soft_coding_keyflex flex
3275: where pap.person_id between stperson and endperson
3276: and pap.person_id = paaf.person_id
3918: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
3919: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei
3920: where paaf1.assignment_id = c_asg_id
3921: and paaf1.person_id = paaf2.person_id
3922: and paaf2.assignment_status_type_id in(select ASSIGNMENT_STATUS_TYPE_ID from per_assignment_status_types past where past.LEGISLATION_CODE is null and past.BUSINESS_GROUP_ID is null
3923: and PER_SYSTEM_STATUS = 'ACTIVE_ASSIGN')
3924: and paei.assignment_id = paaf2.assignment_id
3925: and paei.AEI_INFORMATION_CATEGORY = 'GB_RTI_AGGREGATION'
3926: and paei. AEI_INFORMATION1 = 'Y'
4729: TO_CHAR(paa.EFFECTIVE_START_DATE,'DD-MON-RRRR') start_date,
4730: paa.EFFECTIVE_END_DATE end_date,
4731: pap.person_id
4732: FROM per_all_assignments_f paa,
4733: per_assignment_status_types past,
4734: per_all_people_f pap
4735: WHERE paa.person_id = pap.person_id
4736: AND paa.assignment_id = c_assignment_id
4737: AND past.ASSIGNMENT_STATUS_TYPE_ID = paa.ASSIGNMENT_STATUS_TYPE_ID