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_PDT_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1836: from per_all_assignments_f

1832: l_dummy number;
1833: --
1834: cursor csr_check_directs(p_person_id number) is
1835: select 1
1836: from per_all_assignments_f
1837: where supervisor_id = p_person_id
1838: and p_start_date between effective_start_date and effective_end_date;
1839: --
1840: begin

Line 3338: l_sup_asg_type per_all_assignments_f.assignment_type%type;

3334: ) is
3335: --
3336: l_proc varchar2(72) := g_package||'chk_supervisor_assignment_id';
3337: l_api_updating boolean;
3338: l_sup_asg_type per_all_assignments_f.assignment_type%type;
3339: --
3340: cursor csr_check_sup_asg is
3341: select assignment_type
3342: from per_all_assignments_f

Line 3342: from per_all_assignments_f

3338: l_sup_asg_type per_all_assignments_f.assignment_type%type;
3339: --
3340: cursor csr_check_sup_asg is
3341: select assignment_type
3342: from per_all_assignments_f
3343: -- where person_id = p_supervisor_id fix for the bug#13870904
3344: where assignment_id = p_supervisor_assignment_id
3345: and p_start_date between
3346: effective_start_date and effective_end_date;