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.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_ASSIGNMENTS_V

Line 1590: FROM hr_h2pi_assignments_v asg

1586:
1587: CURSOR csr_ed_assignment (p_asg_id NUMBER,
1588: p_esd DATE) IS
1589: SELECT *
1590: FROM hr_h2pi_assignments_v asg
1591: WHERE asg.assignment_id = p_asg_id
1592: AND p_esd BETWEEN asg.effective_start_date
1593: AND asg.effective_end_date;
1594:

Line 1651: v_ed_asg hr_h2pi_assignments_v%ROWTYPE;

1647:
1648: l_proc VARCHAR2(72) := g_package||'upload_assignment';
1649:
1650: v_ud_asg hr_h2pi_assignments%ROWTYPE;
1651: v_ed_asg hr_h2pi_assignments_v%ROWTYPE;
1652: v_ud_pos hr_h2pi_periods_of_service%ROWTYPE;
1653:
1654: l_person_id per_all_people_f.person_id%TYPE;
1655: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 4955: FROM hr_h2pi_assignments_v asg

4951: p_person_id NUMBER) IS
4952:
4953: CURSOR csr_ed_assignment (p_per_id NUMBER) IS
4954: SELECT DISTINCT asg.assignment_id
4955: FROM hr_h2pi_assignments_v asg
4956: WHERE asg.person_id = p_per_id;
4957:
4958: CURSOR csr_city_pct (p_ud_iv_id1 NUMBER,
4959: p_ud_iv_id2 NUMBER,