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

Line 159: FROM per_all_assignments_f paf

155: -- NOTE: We need to use the primary assignment because we're trying to
156: -- derive the manager id of the login person, not the action employee.
157: CURSOR csr_get_mgr_id_of_login IS
158: SELECT paf.supervisor_id
159: FROM per_all_assignments_f paf
160: ,per_all_people_f ppf
161: WHERE ppf.person_id = ln_creator_person_id
162: and paf.person_id = ppf.person_id
163: and ld_effective_date between ppf.effective_start_date

Line 458: || DESCRIPTION: This changes the per_all_assignments_f.supervisor_id attribute

454:
455: /*
456: ||===========================================================================
457: || PROCEDURE: update_supervisor
458: || DESCRIPTION: This changes the per_all_assignments_f.supervisor_id attribute
459: || to the value of the passed in parm p_supervisor_id.
460: ||===========================================================================
461: */
462:

Line 475: -- Changed from per_assignments_f to per_all_assignments_f. This is

471: p_validate BOOLEAN )
472: IS
473:
474: -- Bug 2130066 Fix Begins: 01/11/2002
475: -- Changed from per_assignments_f to per_all_assignments_f. This is
476: -- necessary because when a Supervisor Security profile restrict to 1 level,
477: -- we cannot get data for 2 levels down or beyond. This will happen when
478: -- the 1st level employee is terminated, we need to change all his direct
479: -- reports to another employee. In this case, the direct reports of the

Line 485: FROM per_all_assignments_f -- Bug 2130066 fix

481: -- profile is restricted to 1 level.
482: CURSOR lc_object_version_no IS
483: SELECT object_version_number,
484: assignment_type
485: FROM per_all_assignments_f -- Bug 2130066 fix
486: WHERE assignment_id = p_assignment_id
487: AND (p_effective_date BETWEEN
488: NVL ( effective_start_date , p_effective_date)
489: AND NVL ( effective_end_date , p_effective_date )) ;

Line 492: ln_assignment_type per_all_assignments_f.assignment_type%type;

488: NVL ( effective_start_date , p_effective_date)
489: AND NVL ( effective_end_date , p_effective_date )) ;
490:
491: ln_object_version_no NUMBER ;
492: ln_assignment_type per_all_assignments_f.assignment_type%type;
493: ln_comment_id NUMBER ;
494: ld_effective_start_date DATE;
495: ld_effective_end_date DATE;
496: lb_no_managers_warning BOOLEAN ;

Line 743: -- Changed from per_assignments_f to per_all_assignments_f. This is

739:
740: IS
741:
742: -- Bug 2130066 Fix Begins: 01/11/2002
743: -- Changed from per_assignments_f to per_all_assignments_f. This is
744: -- necessary because when a Supervisor Security profile restrict to 1 level
745: -- ,we cannot get data for 2 levels down or beyond. This will happen when
746: -- the 1st level employee is terminated, we need to change all his direct
747: -- reports to another employee. In this case, the direct reports of the

Line 753: FROM per_all_assignments_f paf, -- Bug 2130066 fix

749: -- Security profile is restricted to 1 level.
750: --
751: cursor lc_assignment_id ( p_person_id NUMBER, p_effective_date date) is
752: SELECT distinct paf.assignment_id
753: FROM per_all_assignments_f paf, -- Bug 2130066 fix
754: per_all_people_f ppf
755: WHERE ppf.person_id = p_person_id
756: AND p_effective_date BETWEEN
757: ppf.effective_start_date AND ppf.effective_end_date

Line 1731: -- Changed from per_assignments_f to per_all_assignments_f. This is

1727: lb_other_manager_warn boolean;
1728: lb_validate BOOLEAN ;
1729:
1730: -- Bug 2130066 Fix Begins: 01/11/2002
1731: -- Changed from per_assignments_f to per_all_assignments_f. This is
1732: -- necessary because when a Supervisor Security profile restrict to 1 level
1733: -- ,we cannot get data for 2 levels down or beyond. This will happen when
1734: -- the 1st level employee is terminated, we need to change all his direct
1735: -- reports to another employee. In this case, the direct reports of the

Line 1742: FROM per_all_assignments_f -- Bug 2130066 fix

1738: --
1739:
1740: CURSOR lc_object_version_no(l_assignment_id number) IS
1741: SELECT object_version_number, assignment_type
1742: FROM per_all_assignments_f -- Bug 2130066 fix
1743: WHERE assignment_id = l_assignment_id
1744: AND (p_effective_date BETWEEN
1745: NVL ( effective_start_date , p_effective_date)
1746: AND NVL ( effective_end_date , p_effective_date )) ;

Line 1754: l_assignment_type per_all_assignments_f.assignment_type%type;

1750: ln_object_version_no NUMBER ;
1751:
1752: -- variables and cursor for applicant_hire
1753: l_object_version_number number;
1754: l_assignment_type per_all_assignments_f.assignment_type%type;
1755: l_per_object_version_number number;
1756: l_employee_number varchar2(30);
1757: l_person_id number;
1758: l_assignment_id number;

Line 1759: l_appl_assignment_type per_all_assignments_f.assignment_type%type;

1755: l_per_object_version_number number;
1756: l_employee_number varchar2(30);
1757: l_person_id number;
1758: l_assignment_id number;
1759: l_appl_assignment_type per_all_assignments_f.assignment_type%type;
1760: l_per_effective_start_date date;
1761: l_per_effective_end_date date;
1762: l_unaccepted_asg_del_warning boolean;
1763: l_assign_payroll_warning boolean;

Line 1778: -- assignment_type from per_all_assignments_f, for assinging

1774: and p_appl_effective_date between effective_start_date
1775: and effective_end_date;
1776:
1777: -- cursor to get the applicant object_version_number,person_id
1778: -- assignment_type from per_all_assignments_f, for assinging
1779: -- a new manager
1780: cursor asg_appl_rec_assign_manager(p_appl_assign_id in number,
1781: p_appl_effective_date in date) is
1782: select object_version_number,

Line 1785: from per_all_assignments_f

1781: p_appl_effective_date in date) is
1782: select object_version_number,
1783: assignment_type,
1784: person_id
1785: from per_all_assignments_f
1786: where assignment_id = p_appl_assign_id
1787: and p_appl_effective_date between effective_start_date
1788: and effective_end_date;
1789:

Line 1791: -- assignment_type from per_all_assignments_f, for assigning

1787: and p_appl_effective_date between effective_start_date
1788: and effective_end_date;
1789:
1790: -- cursor to get the applicant object_version_number
1791: -- assignment_type from per_all_assignments_f, for assigning
1792: -- a new direct reports
1793: cursor asg_appl_rec_assign_directs(p_appl_person_id in number,
1794: p_appl_effective_date in date) is
1795: select object_version_number,

Line 1797: from per_all_assignments_f

1793: cursor asg_appl_rec_assign_directs(p_appl_person_id in number,
1794: p_appl_effective_date in date) is
1795: select object_version_number,
1796: assignment_type
1797: from per_all_assignments_f
1798: where person_id = p_appl_person_id
1799: and p_appl_effective_date between effective_start_date
1800: and effective_end_date;
1801:

Line 1805: from per_all_assignments_f

1801:
1802:
1803: cursor csr_assignment is
1804: select assignment_id
1805: from per_all_assignments_f
1806: where assignment_id = p_assignment_id;
1807:
1808: -- Bug Fix 3041328
1809: cursor csr_person is

Line 1829: l_applicant_assignment_id per_all_assignments_f.assignment_id%type;

1825: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
1826: l_current_employee_flag per_all_people_f.current_employee_flag%type;
1827: l_current_npw_flag per_all_people_f.current_npw_flag%type;
1828: l_applicant_person_id per_all_people_f.person_id%type;
1829: l_applicant_assignment_id per_all_assignments_f.assignment_id%type;
1830: l_applicant_effective_date per_all_people_f.effective_start_date%type;
1831:
1832: -- Bug Fix 3041328
1833: l_supervisor_id per_all_people_F.person_id%type;

Line 1834: -- l_supervisor_assign_id per_all_assignments_f.assignment_id%type;

1830: l_applicant_effective_date per_all_people_f.effective_start_date%type;
1831:
1832: -- Bug Fix 3041328
1833: l_supervisor_id per_all_people_F.person_id%type;
1834: -- l_supervisor_assign_id per_all_assignments_f.assignment_id%type;
1835: l_supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type;
1836:
1837: l_proc constant varchar2(100) := g_package || ' update_asg';
1838: BEGIN

Line 1835: l_supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type;

1831:
1832: -- Bug Fix 3041328
1833: l_supervisor_id per_all_people_F.person_id%type;
1834: -- l_supervisor_assign_id per_all_assignments_f.assignment_id%type;
1835: l_supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type;
1836:
1837: l_proc constant varchar2(100) := g_package || ' update_asg';
1838: BEGIN
1839: hr_utility.set_location('Entering'|| l_proc,5);