DBA Data[Home] [Help]

APPS.PAY_PL_POST_TERMINATION_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 17: hr_soft_coding_keyflex kflex

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
20: and PER_SYSTEM_STATUS='TERM_ASSIGN'
21: and kflex.soft_coding_keyflex_id=paaf.soft_coding_keyflex_id