APPS.PER_FR_TERMINATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 227: from per_all_assignments_f

223: l_input_value_id Number;
224: --
225: cursor c_get_asg is
226: select assignment_id
227: from per_all_assignments_f
228: where person_id = g_person_id
229: and l_effective_date
230: between effective_start_date and effective_end_date
231: and primary_flag = 'Y';

Line 411: from per_all_assignments_f a

407: , a.object_version_number
408: , a.soft_coding_keyflex_id
409: , scl.segment4
410: , scl.segment2
411: from per_all_assignments_f a
412: , hr_soft_coding_keyflex scl
413: , per_assignment_status_types ast
414: where a.period_of_service_id = p_period_of_service_id
415: and p_actual_termination_date = a.effective_end_date

Line 567: from per_all_assignments_f a

563: , a.object_version_number
564: , a.soft_coding_keyflex_id
565: , scl.segment4
566: , scl.segment2
567: from per_all_assignments_f a
568: , hr_soft_coding_keyflex scl
569: where a.period_of_service_id = p_period_of_service_id
570: and p_actual_termination_date = a.effective_end_date
571: and a.soft_coding_keyflex_id = scl.soft_coding_keyflex_id (+);

Line 792: from per_all_assignments_f a

788: , scl.segment2
789: , decode(effective_end_date
790: ,p_actual_termination_date,p_actual_termination_date
791: ,p_actual_termination_date+1) effective_date
792: from per_all_assignments_f a
793: , hr_soft_coding_keyflex scl
794: where period_of_service_id = p_period_of_service_id
795: and (effective_end_date = p_actual_termination_date
796: or effective_start_date = p_actual_termination_date+1