eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_24Q_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 2531: ,hr_soft_coding_keyflex hscl

2527: CURSOR c_get_distinct_gre(p_assignment_id NUMBER)
2528: IS
2529: SELECT DISTINCT(hscl.segment1) gre
2530: FROM per_all_assignments_f paf
2531: ,hr_soft_coding_keyflex hscl
2532: WHERE hscl.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
2533: AND paf.assignment_id =paf.assignment_id
2534: AND paf.assignment_id = p_assignment_id
2535: AND ( paf.effective_start_date BETWEEN g_fin_start_date AND g_end_date

Line 2546: ,hr_soft_coding_keyflex scl

2542: SELECT GREATEST(asg.effective_start_date,g_fin_start_date) start_date
2543: ,LEAST(asg.effective_end_date,g_fin_end_date) end_date
2544: ,scl.segment1
2545: FROM per_assignments_f asg
2546: ,hr_soft_coding_keyflex scl
2547: ,pay_assignment_actions paa
2548: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
2549: AND paa.assignment_action_id = p_assignment_action_id
2550: AND asg.assignment_id = paa.assignment_id