DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 4373: ,hr_soft_coding_keyflex scl

4369: SELECT GREATEST(asg.effective_start_date,g_fin_start_date) start_date
4370: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
4371: ,scl.segment1
4372: FROM per_assignments_f asg
4373: ,hr_soft_coding_keyflex scl
4374: ,pay_assignment_actions paa
4375: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
4376: AND paa.assignment_action_id = p_action_context_id
4377: AND asg.assignment_id = paa.assignment_id