APPS.PER_FR_TERMINATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 222: from per_all_assignments_f

218: l_input_value_id Number;
219: --
220: cursor c_get_asg is
221: select assignment_id
222: from per_all_assignments_f
223: where person_id = g_person_id
224: and l_effective_date
225: between effective_start_date and effective_end_date
226: and primary_flag = 'Y';

Line 406: from per_all_assignments_f a

402: , a.object_version_number
403: , a.soft_coding_keyflex_id
404: , scl.segment4
405: , scl.segment2
406: from per_all_assignments_f a
407: , hr_soft_coding_keyflex scl
408: , per_assignment_status_types ast
409: where a.period_of_service_id = p_period_of_service_id
410: and p_actual_termination_date = a.effective_end_date

Line 562: from per_all_assignments_f a

558: , a.object_version_number
559: , a.soft_coding_keyflex_id
560: , scl.segment4
561: , scl.segment2
562: from per_all_assignments_f a
563: , hr_soft_coding_keyflex scl
564: where a.period_of_service_id = p_period_of_service_id
565: and p_actual_termination_date = a.effective_end_date
566: and a.soft_coding_keyflex_id = scl.soft_coding_keyflex_id (+);

Line 787: from per_all_assignments_f a

783: , scl.segment2
784: , decode(effective_end_date
785: ,p_actual_termination_date,p_actual_termination_date
786: ,p_actual_termination_date+1) effective_date
787: from per_all_assignments_f a
788: , hr_soft_coding_keyflex scl
789: where period_of_service_id = p_period_of_service_id
790: and (effective_end_date = p_actual_termination_date
791: or effective_start_date = p_actual_termination_date+1