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 1020: ,hr_soft_coding_keyflex target

1016: ,c_period_end in date) IS
1017: SELECT COUNT(*)
1018: FROM per_assignments_f asg
1019: ,per_assignment_status_types past
1020: ,hr_soft_coding_keyflex target
1021: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1022: AND past.per_system_status = 'ACTIVE_ASSIGN'
1023: AND asg.effective_start_date BETWEEN c_period_start
1024: AND c_period_end

Line 1041: ,hr_soft_coding_keyflex target

1037: ,asg.effective_end_date End_Date
1038: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
1039: FROM per_assignments_f asg
1040: ,per_assignment_status_types past
1041: ,hr_soft_coding_keyflex target
1042: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
1043: AND past.per_system_status = 'ACTIVE_ASSIGN'
1044: AND asg.effective_start_date BETWEEN c_period_start
1045: AND c_period_end

Line 3196: ,hr_soft_coding_keyflex sck

3192: ,fnd_number.canonical_to_number(new_val1) ptp
3193: FROM per_all_assignments_f asg,
3194: ben_ext_chg_evt_log log
3195: ,per_assignment_status_types past
3196: ,hr_soft_coding_keyflex sck
3197: WHERE asg.assignment_id = p_assignment_id
3198: AND asg.assignment_status_type_id = past.assignment_status_type_id
3199: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
3200: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 3385: ,hr_soft_coding_keyflex sck

3381: ,effective_end_date end_date
3382: ,least(fnd_number.canonical_to_number(nvl(sck.segment29,100)),125) ptp
3383: FROM per_all_assignments_f asg
3384: ,per_assignment_status_types past
3385: ,hr_soft_coding_keyflex sck
3386: WHERE asg.assignment_id = p_assignment_id
3387: AND asg.assignment_status_type_id = past.assignment_status_type_id
3388: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
3389: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 3401: ,hr_soft_coding_keyflex sck

3397: CURSOR c_get_min_st_dt IS
3398: SELECT effective_start_date
3399: FROM per_all_assignments_f asg
3400: ,per_assignment_status_types past
3401: ,hr_soft_coding_keyflex sck
3402: WHERE asg.assignment_id = p_assignment_id
3403: AND asg.assignment_status_type_id = past.assignment_status_type_id
3404: AND sck.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
3405: AND past.per_system_status = 'ACTIVE_ASSIGN'

Line 3412: ,hr_soft_coding_keyflex sck1

3408: AND g_extract_params(p_business_group_id).extract_end_date
3409: AND EXISTS (SELECT 1
3410: FROM per_all_assignments_f asg1
3411: ,per_assignment_status_types past1
3412: ,hr_soft_coding_keyflex sck1
3413: WHERE asg1.assignment_id = p_assignment_id
3414: AND asg1.effective_end_date = asg.effective_start_date - 1
3415: AND asg1.assignment_status_type_id = past1.assignment_status_type_id
3416: AND sck1.soft_coding_keyflex_id = asg1.soft_coding_keyflex_id

Line 10718: ,hr_soft_coding_keyflex target

10714: SELECT asg.effective_start_date Start_Date
10715: ,asg.effective_end_date End_Date
10716: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
10717: FROM per_assignments_f asg
10718: ,hr_soft_coding_keyflex target
10719: ,per_assignment_status_types past
10720: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
10721: AND asg.assignment_id = c_asg_id
10722: AND target.enabled_flag = 'Y'

Line 10867: ,hr_soft_coding_keyflex target

10863: CURSOR c_copos_ptp_chg (c_asg_id IN NUMBER
10864: ,c_eff_date IN DATE ) IS
10865: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) ptp
10866: FROM per_assignments_f asg
10867: ,hr_soft_coding_keyflex target
10868: ,per_assignment_status_types past
10869: WHERE target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
10870: AND asg.assignment_id = c_asg_id
10871: AND target.enabled_flag = 'Y'

Line 14132: ,hr_soft_coding_keyflex scl

14128: --from the soft coding key flex
14129: CURSOR c_get_emp_code IS
14130: SELECT scl.SEGMENT2||scl.SEGMENT3
14131: FROM per_all_assignments_f asg
14132: ,hr_soft_coding_keyflex scl
14133: WHERE asg.assignment_id = p_assignment_id
14134: AND p_effective_date BETWEEN asg.effective_start_date
14135: AND asg.effective_end_date
14136: AND asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id;