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.PQP_NL_PENSION_EXTRACTS dependencies on HR_SOFT_CODING_KEYFLEX

Line 664: ,hr_soft_coding_keyflex target

660: CURSOR c_cur_ptp (c_eff_dt IN DATE
661: ,c_asg_id IN NUMBER) IS
662: SELECT LEAST(fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')),125) ptp
663: FROM per_assignments_f asg
664: ,hr_soft_coding_keyflex target
665: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
666: AND asg.assignment_id = c_asg_id
667: AND target.enabled_flag = 'Y'
668: AND trunc(c_eff_dt) BETWEEN asg.effective_start_date AND

Line 681: ,hr_soft_coding_keyflex target

677: CURSOR c_cur_sal_hour (c_eff_dt IN DATE
678: ,c_asg_id IN NUMBER) IS
679: SELECT nvl(hourly_salaried_code,'H') hourly_salaried_code
680: FROM per_assignments_f asg
681: ,hr_soft_coding_keyflex target
682: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
683: AND asg.assignment_id = c_asg_id
684: AND target.enabled_flag = 'Y'
685: AND trunc(c_eff_dt) BETWEEN asg.effective_start_date AND

Line 1039: ,hr_soft_coding_keyflex target

1035: ,c_period_end in date) IS
1036: SELECT COUNT(*)
1037: FROM per_assignments_f asg
1038: ,per_assignment_status_types past
1039: ,hr_soft_coding_keyflex target
1040: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1041: AND past.per_system_status = 'ACTIVE_ASSIGN'
1042: AND asg.effective_start_date BETWEEN c_period_start
1043: AND c_period_end

Line 1060: ,hr_soft_coding_keyflex target

1056: ,asg.effective_end_date End_Date
1057: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
1058: FROM per_assignments_f asg
1059: ,per_assignment_status_types past
1060: ,hr_soft_coding_keyflex target
1061: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1062: AND past.per_system_status = 'ACTIVE_ASSIGN'
1063: AND asg.effective_start_date BETWEEN c_period_start
1064: AND c_period_end

Line 3217: ,hr_soft_coding_keyflex sck

3213: ,fnd_number.canonical_to_number(new_val1) ptp
3214: FROM per_all_assignments_f asg,
3215: ben_ext_chg_evt_log log
3216: ,per_assignment_status_types past
3217: ,hr_soft_coding_keyflex sck
3218: WHERE asg.assignment_id = p_assignment_id
3219: AND asg.assignment_status_type_id = past.assignment_status_type_id
3220: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
3221: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 3406: ,hr_soft_coding_keyflex sck

3402: ,effective_end_date end_date
3403: ,least(fnd_number.canonical_to_number(nvl(sck.segment29,100)),125) ptp
3404: FROM per_all_assignments_f asg
3405: ,per_assignment_status_types past
3406: ,hr_soft_coding_keyflex sck
3407: WHERE asg.assignment_id = p_assignment_id
3408: AND asg.assignment_status_type_id = past.assignment_status_type_id
3409: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
3410: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 3422: ,hr_soft_coding_keyflex sck

3418: CURSOR c_get_min_st_dt IS
3419: SELECT effective_start_date
3420: FROM per_all_assignments_f asg
3421: ,per_assignment_status_types past
3422: ,hr_soft_coding_keyflex sck
3423: WHERE asg.assignment_id = p_assignment_id
3424: AND asg.assignment_status_type_id = past.assignment_status_type_id
3425: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
3426: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 3433: ,hr_soft_coding_keyflex sck1

3429: AND g_extract_params(p_business_group_id).extract_end_date
3430: AND EXISTS (SELECT 1
3431: FROM per_all_assignments_f asg1
3432: ,per_assignment_status_types past1
3433: ,hr_soft_coding_keyflex sck1
3434: WHERE asg1.assignment_id = p_assignment_id
3435: AND asg1.effective_end_date = asg.effective_start_date - 1
3436: AND asg1.assignment_status_type_id = past1.assignment_status_type_id
3437: AND sck1.soft_coding_keyflex_id = asg1.soft_coding_keyflex_id

Line 3600: ,hr_soft_coding_keyflex target

3596: SELECT DISTINCT asg.effective_start_date Start_Date
3597: ,asg.effective_end_date End_Date
3598: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100'))*100 ptp
3599: FROM per_assignments_f asg
3600: ,hr_soft_coding_keyflex target
3601: WHERE asg.assignment_id = p_asg_id
3602: AND asg.effective_start_date BETWEEN p_start_date AND nvl(p_end_date,to_date('31-12-4712','dd-mm-rrrr'))
3603: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
3604: AND target.enabled_flag = 'Y'

Line 3642: ,hr_soft_coding_keyflex target

3638: SELECT DISTINCT asg.effective_start_date Start_Date
3639: ,asg.effective_end_date End_Date
3640: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100'))*100 ptp
3641: FROM per_assignments_f asg
3642: ,hr_soft_coding_keyflex target
3643: WHERE asg.assignment_id = p_asg_id
3644: AND asg.effective_start_date BETWEEN p_start_date AND nvl(p_end_date,to_date('31-12-4712','dd-mm-rrrr'))
3645: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
3646: AND target.enabled_flag = 'Y'

Line 11057: ,hr_soft_coding_keyflex target

11053: SELECT asg.effective_start_date Start_Date
11054: ,asg.effective_end_date End_Date
11055: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
11056: FROM per_assignments_f asg
11057: ,hr_soft_coding_keyflex target
11058: ,per_assignment_status_types past
11059: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
11060: AND asg.assignment_id = c_asg_id
11061: AND target.enabled_flag = 'Y'

Line 11206: ,hr_soft_coding_keyflex target

11202: CURSOR c_copos_ptp_chg (c_asg_id IN NUMBER
11203: ,c_eff_date IN DATE ) IS
11204: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
11205: FROM per_assignments_f asg
11206: ,hr_soft_coding_keyflex target
11207: ,per_assignment_status_types past
11208: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
11209: AND asg.assignment_id = c_asg_id
11210: AND target.enabled_flag = 'Y'

Line 14501: ,hr_soft_coding_keyflex scl

14497: --from the soft coding key flex
14498: CURSOR c_get_emp_code IS
14499: SELECT scl.SEGMENT2||scl.SEGMENT3
14500: FROM per_all_assignments_f asg
14501: ,hr_soft_coding_keyflex scl
14502: WHERE asg.assignment_id = p_assignment_id
14503: AND p_effective_date BETWEEN asg.effective_start_date
14504: AND asg.effective_end_date
14505: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;