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 2472: ,hr_soft_coding_keyflex hck

2468:
2469: CURSOR c_get_report_term_rehire (cp_asg_id IN NUMBER) IS
2470: SELECT segment10
2471: FROM per_all_assignments_f paf
2472: ,hr_soft_coding_keyflex hck
2473: WHERE paf.assignment_id = cp_asg_id
2474: AND paf.soft_coding_keyflex_id = hck.soft_coding_keyflex_id;
2475:
2476: CURSOR c_get_asg_scl (cp_asg_id IN NUMBER

Line 2481: ,hr_soft_coding_keyflex hck

2477: ,cp_effective_date IN DATE) IS
2478: SELECT segment1
2479: ,assignment_number
2480: FROM per_all_assignments_f paf
2481: ,hr_soft_coding_keyflex hck
2482: WHERE paf.assignment_id = cp_asg_id
2483: AND cp_effective_date BETWEEN paf.effective_start_date
2484: AND paf.effective_end_date
2485: AND paf.soft_coding_keyflex_id = hck.soft_coding_keyflex_id;

Line 2601: ,hr_soft_coding_keyflex hck

2597: CURSOR c_salary_type ( cp_assignment_id IN NUMBER
2598: ,cp_effective_date IN DATE) IS
2599: SELECT hck.segment6
2600: FROM per_all_assignments_f paf
2601: ,hr_soft_coding_keyflex hck
2602: WHERE paf.assignment_id = cp_assignment_id
2603: AND paf.soft_coding_keyflex_id = hck.soft_coding_keyflex_id
2604: AND cp_effective_date BETWEEN paf.effective_start_date
2605: AND paf.effective_end_date ;

Line 3797: FROM hr_soft_coding_keyflex hsc,

3793:
3794: CURSOR c_work_schdl ( cp_soft_cod_kflx_id IN NUMBER ) IS
3795: SELECT hsc.segment6 salary_type
3796: ,puc.user_column_name work_schedule
3797: FROM hr_soft_coding_keyflex hsc,
3798: pay_user_columns puc
3799: WHERE hsc.soft_coding_keyflex_id = cp_soft_cod_kflx_id
3800: AND hsc.segment4 = puc.user_column_id(+);
3801: