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_MX_SOC_SEC_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 2348: ,hr_soft_coding_keyflex hck

2344:
2345: CURSOR c_get_report_term_rehire (cp_asg_id IN NUMBER) IS
2346: SELECT segment10
2347: FROM per_all_assignments_f paf
2348: ,hr_soft_coding_keyflex hck
2349: WHERE paf.assignment_id = cp_asg_id
2350: AND paf.soft_coding_keyflex_id = hck.soft_coding_keyflex_id;
2351:
2352: CURSOR c_get_asg_scl (cp_asg_id IN NUMBER

Line 2357: ,hr_soft_coding_keyflex hck

2353: ,cp_effective_date IN DATE) IS
2354: SELECT segment1
2355: ,assignment_number
2356: FROM per_all_assignments_f paf
2357: ,hr_soft_coding_keyflex hck
2358: WHERE paf.assignment_id = cp_asg_id
2359: AND cp_effective_date BETWEEN paf.effective_start_date
2360: AND paf.effective_end_date
2361: AND paf.soft_coding_keyflex_id = hck.soft_coding_keyflex_id;

Line 3584: FROM hr_soft_coding_keyflex hsc,

3580:
3581: CURSOR c_work_schdl ( cp_soft_cod_kflx_id IN NUMBER ) IS
3582: SELECT hsc.segment6 salary_type
3583: ,puc.user_column_name work_schedule
3584: FROM hr_soft_coding_keyflex hsc,
3585: pay_user_columns puc
3586: WHERE hsc.soft_coding_keyflex_id = cp_soft_cod_kflx_id
3587: AND hsc.segment4 = puc.user_column_id(+);
3588: