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 529: FROM hr_soft_coding_keyflex hr_keyflex,per_assignments_f ASSIGN

525:
526: CURSOR
527: c_get_max_si_values(c_assignment_id IN NUMBER,c_effective_date IN DATE) IS
528: SELECT SEGMENT26,segment27
529: FROM hr_soft_coding_keyflex hr_keyflex,per_assignments_f ASSIGN
530: WHERE ASSIGN.assignment_id = c_assignment_id
531: AND hr_keyflex.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id
532: AND hr_keyflex.enabled_flag = 'Y'
533: AND trunc(c_effective_date) BETWEEN ASSIGN.effective_start_date AND ASSIGN.effective_end_date;

Line 2035: ,hr_soft_coding_keyflex target

2031:
2032: CURSOR c_pt_cur (c_effective_date IN DATE) IS
2033: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
2034: FROM per_assignments_f asg
2035: ,hr_soft_coding_keyflex target
2036: WHERE asg.assignment_id = p_assignment_id
2037: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
2038: AND trunc(c_effective_date) between asg.effective_start_date
2039: AND asg.effective_end_date

Line 3572: FROM hr_soft_coding_keyflex target,

3568:
3569: --Cursor to derive the part time percetage value
3570: CURSOR c_get_fte(c_assignment_id IN per_all_assignments_f.assignment_id%TYPE) IS
3571: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100'))
3572: FROM hr_soft_coding_keyflex target,
3573: per_all_assignments_f ASSIGN
3574: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date AND
3575: ASSIGN.effective_end_date
3576: AND ASSIGN.assignment_id = c_assignment_id

Line 5139: ,hr_soft_coding_keyflex target

5135: asg.effective_end_date) End_Dt
5136: ,fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
5137: FROM per_assignments_f asg
5138: ,per_assignment_status_types past
5139: ,hr_soft_coding_keyflex target
5140: WHERE asg.assignment_status_type_id = past.assignment_status_type_id
5141: AND past.per_system_status = 'ACTIVE_ASSIGN'
5142: AND asg.effective_end_date >= c_effective_date
5143: AND asg.assignment_id = p_assignment_id