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

Line 571: FROM hr_soft_coding_keyflex hr_keyflex,per_assignments_f ASSIGN

567:
568: CURSOR
569: c_get_max_si_values(c_assignment_id IN NUMBER,c_effective_date IN DATE) IS
570: SELECT SEGMENT26,segment27
571: FROM hr_soft_coding_keyflex hr_keyflex,per_assignments_f ASSIGN
572: WHERE ASSIGN.assignment_id = c_assignment_id
573: AND hr_keyflex.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id
574: AND hr_keyflex.enabled_flag = 'Y'
575: AND trunc(c_effective_date) BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date;

Line 2100: ,hr_soft_coding_keyflex target

2096:
2097: CURSOR c_pt_cur (c_effective_date IN DATE) IS
2098: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
2099: FROM per_assignments_f asg
2100: ,hr_soft_coding_keyflex target
2101: WHERE asg.assignment_id = p_assignment_id
2102: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
2103: AND trunc(c_effective_date) between asg.effective_start_date
2104: AND asg.effective_end_date

Line 3669: FROM hr_soft_coding_keyflex target,

3665:
3666: --Cursor to derive the part time percetage value
3667: CURSOR c_get_fte(c_assignment_id IN per_all_assignments_f.assignment_id%TYPE) IS
3668: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100'))
3669: FROM hr_soft_coding_keyflex target,
3670: per_all_assignments_f ASSIGN
3671: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date AND
3672: ASSIGN.effective_end_date
3673: AND ASSIGN.assignment_id = c_assignment_id

Line 5236: ,hr_soft_coding_keyflex target

5232: asg.effective_end_date) End_Dt
5233: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
5234: FROM per_assignments_f asg
5235: ,per_assignment_status_types past
5236: ,hr_soft_coding_keyflex target
5237: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
5238: AND past.per_system_status = 'ACTIVE_ASSIGN'
5239: AND asg.effective_end_date >= c_effective_date
5240: AND asg.assignment_id = p_assignment_id