DBA Data[Home] [Help]

APPS.PAY_PL_POST_TERMINATION_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 15: from per_all_assignments_f paaf,

11: cursor csr_term_normal_assignments is
12: select min(paaf.effective_start_date),
13: paaf.assignment_id,
14: paaf.person_id
15: from per_all_assignments_f paaf,
16: per_assignment_status_types past,
17: hr_soft_coding_keyflex kflex
18: where period_of_service_id=p_period_of_service_id
19: and past.ASSIGNMENT_STATUS_TYPE_ID=paaf.ASSIGNMENT_STATUS_TYPE_ID