DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 2425: ,hr_soft_coding_keyflex hscl

2421: CURSOR c_get_distinct_gre(p_assignment_id NUMBER)
2422: IS
2423: SELECT DISTINCT(hscl.segment1) gre
2424: FROM per_all_assignments_f paf
2425: ,hr_soft_coding_keyflex hscl
2426: WHERE hscl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
2427: AND paf.assignment_id =paf.assignment_id
2428: AND paf.assignment_id = p_assignment_id
2429: AND ( paf.effective_start_date BETWEEN g_fin_start_date AND g_end_date

Line 2440: ,hr_soft_coding_keyflex scl

2436: SELECT GREATEST(asg.effective_start_date,g_fin_start_date) start_date
2437: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
2438: ,scl.segment1
2439: FROM per_assignments_f asg
2440: ,hr_soft_coding_keyflex scl
2441: ,pay_assignment_actions paa
2442: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2443: AND paa.assignment_action_id = p_assignment_action_id
2444: AND asg.assignment_id = paa.assignment_id