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_PGGM_FUNCTIONS dependencies on PER_ASSIGNMENTS_F

Line 1214: FROM per_assignments_f asg

1210: --assignment standard conditions for a given effective date
1211: --
1212: CURSOR c_pt_cur (c_effective_date IN DATE) IS
1213: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
1214: FROM per_assignments_f asg
1215: ,hr_soft_coding_keyflex target
1216: WHERE asg.assignment_id = p_assignment_id
1217: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1218: AND trunc(c_effective_date) between asg.effective_start_date

Line 1880: FROM per_assignments_f asg

1876: --assignment standard conditions for a given effective date
1877: --
1878: CURSOR c_get_ptp(c_effective_date IN DATE) IS
1879: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'0')) pt_perc
1880: FROM per_assignments_f asg
1881: ,hr_soft_coding_keyflex target
1882: WHERE asg.assignment_id = p_assignment_id
1883: AND target.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
1884: AND c_effective_date between asg.effective_start_date

Line 1900: FROM per_assignments_f asg

1896: ,nvl(asg.normal_hours,0) total_hours
1897: ,nvl(asg.frequency,'W') freq
1898: ,asg.effective_start_date start_date
1899: ,asg.effective_end_date end_date
1900: FROM per_assignments_f asg
1901: ,per_assignment_status_types ast
1902: ,hr_soft_coding_keyflex target
1903: WHERE asg.assignment_id = p_assignment_id
1904: AND asg.assignment_status_type_id = ast.assignment_status_type_id