DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 4697: ,hr_soft_coding_keyflex scl

4693: SELECT GREATEST(asg.effective_start_date,g_fin_start_date) start_date
4694: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
4695: ,scl.segment1
4696: FROM per_assignments_f asg
4697: ,hr_soft_coding_keyflex scl
4698: ,pay_assignment_actions paa
4699: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
4700: AND paa.assignment_action_id = p_action_context_id
4701: AND asg.assignment_id = paa.assignment_id