APPS.PER_MX_SSAFFL_ARCHIVE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 2455: per_assignment_status_types pas

2451: select paf.person_id,paf.assignment_number,paf.location_id,
2452: paf.soft_coding_keyflex_id, pas.per_system_status,
2453: paf.business_group_id
2454: from per_all_assignments_f paf,
2455: per_assignment_status_types pas
2456: where paf.assignment_id = cp_assignment_id
2457: and pas.assignment_status_type_id = paf.assignment_status_type_id
2458: and cp_effective_date between paf.effective_start_date
2459: and paf.effective_end_date ;

Line 2642: select PER_SYSTEM_STATUS from per_assignment_status_types

2638: IS
2639:
2640: cursor c_asg_status_type(cp_assignment_status_type_id in number)
2641: is
2642: select PER_SYSTEM_STATUS from per_assignment_status_types
2643: where assignment_status_type_id = cp_assignment_status_type_id ;
2644:
2645:
2646: int_pkg_events pay_interpreter_pkg.t_detailed_output_table_type;