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_PEOPLE_F

Line 100: ('PER_ALL_PEOPLE_F'

96: ,hao.business_group_id,0,1
97: ) +
98: decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
99: ,HR_SECURITY.SHOW_RECORD
100: ('PER_ALL_PEOPLE_F'
101: ,PAP.PERSON_ID
102: ,PAP.PERSON_TYPE_ID
103: ,PAP.EMPLOYEE_NUMBER
104: ,PAP.APPLICANT_NUMBER

Line 118: ,per_all_people_f pap, hr_all_organization_units hao

114: )
115: ),0,'Y','N'
116: ) has_update_access
117: FROM hr_organization_information cost_center
118: ,per_all_people_f pap, hr_all_organization_units hao
119: WHERE cost_center.ORG_INFORMATION2 = to_char(pap.person_id)
120: AND cost_center.org_information_context = 'Organization Name Alias'
121: AND pap.person_id = ln_person_id
122: AND (pap.current_employee_flag = 'Y' or pap.current_npw_flag = 'Y')

Line 160: ,per_all_people_f ppf

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
164: and ppf.effective_end_date

Line 754: per_all_people_f ppf

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
758: AND paf.person_id = ppf.person_id

Line 1768: -- per_all_people_f

1764: l_attribute_update_mode varchar2(50);
1765: isApplicantSubordinate boolean := true;
1766:
1767: -- cursor to get the applicant object_version_number from
1768: -- per_all_people_f
1769: cursor per_applicant_rec(p_appl_person_id in number,
1770: p_appl_effective_date in date) is
1771: select object_version_number
1772: from per_all_people_f

Line 1772: from per_all_people_f

1768: -- per_all_people_f
1769: cursor per_applicant_rec(p_appl_person_id in number,
1770: p_appl_effective_date in date) is
1771: select object_version_number
1772: from per_all_people_f
1773: where person_id = p_appl_person_id
1774: and p_appl_effective_date between effective_start_date
1775: and effective_end_date;
1776:

Line 1811: from per_all_people_f

1807:
1808: -- Bug Fix 3041328
1809: cursor csr_person is
1810: select person_id
1811: from per_all_people_f
1812: where person_id = p_supervisor_id;
1813:
1814: CURSOR lc_get_current_applicant_flag
1815: (p_person_id in number

Line 1821: FROM per_all_people_f per

1817: IS
1818: SELECT per.current_applicant_flag,
1819: per.current_employee_flag,
1820: per.current_npw_flag
1821: FROM per_all_people_f per
1822: WHERE per.person_id = p_person_id
1823: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
1824:
1825: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;

Line 1825: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;

1821: FROM per_all_people_f per
1822: WHERE per.person_id = p_person_id
1823: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
1824:
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;

Line 1826: l_current_employee_flag per_all_people_f.current_employee_flag%type;

1822: WHERE per.person_id = p_person_id
1823: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
1824:
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;

Line 1827: l_current_npw_flag per_all_people_f.current_npw_flag%type;

1823: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
1824:
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:

Line 1828: l_applicant_person_id per_all_people_f.person_id%type;

1824:
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

Line 1830: l_applicant_effective_date per_all_people_f.effective_start_date%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;
1834: -- l_supervisor_assign_id per_all_assignments_f.assignment_id%type;

Line 1833: l_supervisor_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;
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';

Line 1949: -- per_all_people_f

1945: itemtype => p_item_type,
1946: itemkey => p_item_key,
1947: aname => 'CURRENT_EFFECTIVE_DATE');
1948: -- first get the object_version_number for the applicant from
1949: -- per_all_people_f
1950:
1951: open per_applicant_rec(l_person_id, l_applicant_effective_date);
1952: fetch per_applicant_rec into l_per_object_version_number;
1953: close per_applicant_rec;

Line 1966: -- per_all_people_f

1962: p_item_type => p_item_type
1963: ,p_item_key => p_item_key
1964: ,p_employee_number => l_employee_number);
1965: -- first get the object_version_number for the applicant from
1966: -- per_all_people_f
1967:
1968: open per_applicant_rec(l_applicant_person_id, l_applicant_effective_date);
1969: fetch per_applicant_rec into l_per_object_version_number;
1970: close per_applicant_rec;