DBA Data[Home] [Help]

APPS.PER_PL_TERMINATION dependencies on HR_SOFT_CODING_KEYFLEX

Line 12: ,hr_soft_coding_keyflex kyflex

8: cursor csr_normal_assignments is
9: select distinct(paaf.assignment_id)
10: from per_all_assignments_f paaf
11: ,per_assignment_status_types past
12: ,hr_soft_coding_keyflex kyflex
13: where paaf.period_of_service_id=p_period_of_service_id
14: and (p_actual_termination_date+1) between paaf.effective_start_date
15: and paaf.effective_end_date
16: and paaf.assignment_status_type_id=past.assignment_status_type_id