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 105: ('PER_ALL_PEOPLE_F'

101: ,hao.business_group_id,0,1
102: ) +
103: decode(decode(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE'
104: ,HR_SECURITY.SHOW_RECORD
105: ('PER_ALL_PEOPLE_F'
106: ,PAP.PERSON_ID
107: ,PAP.PERSON_TYPE_ID
108: ,PAP.EMPLOYEE_NUMBER
109: ,PAP.APPLICANT_NUMBER

Line 123: ,per_all_people_f pap, hr_all_organization_units hao

119: )
120: ),0,'Y','N'
121: ) has_update_access
122: FROM hr_organization_information cost_center
123: ,per_all_people_f pap, hr_all_organization_units hao
124: WHERE cost_center.ORG_INFORMATION2 = to_char(pap.person_id)
125: AND cost_center.org_information_context = 'Organization Name Alias'
126: AND pap.person_id = ln_person_id
127: AND (pap.current_employee_flag = 'Y' or pap.current_npw_flag = 'Y')

Line 165: ,per_all_people_f ppf

161: -- derive the manager id of the login person, not the action employee.
162: CURSOR csr_get_mgr_id_of_login IS
163: SELECT paf.supervisor_id
164: FROM per_all_assignments_f paf
165: ,per_all_people_f ppf
166: WHERE ppf.person_id = ln_creator_person_id
167: and paf.person_id = ppf.person_id
168: and ld_effective_date between ppf.effective_start_date
169: and ppf.effective_end_date

Line 799: per_all_people_f ppf

795: --
796: cursor lc_assignment_id ( p_person_id NUMBER, p_effective_date date) is
797: SELECT distinct paf.assignment_id
798: FROM per_all_assignments_f paf, -- Bug 2130066 fix
799: per_all_people_f ppf
800: WHERE ppf.person_id = p_person_id
801: AND p_effective_date BETWEEN
802: ppf.effective_start_date AND ppf.effective_end_date
803: AND paf.person_id = ppf.person_id

Line 1803: l_person_name per_all_people_f.global_name%type;

1799: l_assignment_type per_all_assignments_f.assignment_type%type;
1800: l_per_object_version_number number;
1801: l_employee_number varchar2(30);
1802: l_person_id number;
1803: l_person_name per_all_people_f.global_name%type;
1804: l_assignment_id number;
1805: l_appl_assignment_type per_all_assignments_f.assignment_type%type;
1806: l_per_effective_start_date date;
1807: l_per_effective_end_date date;

Line 1816: -- per_all_people_f

1812: e_future_assignment_change EXCEPTION;
1813: l_current_person_id varchar2(25) default null;
1814: l_supervisor_old_id number;
1815: -- cursor to get the applicant object_version_number from
1816: -- per_all_people_f
1817: cursor per_applicant_rec(p_appl_person_id in number,
1818: p_appl_effective_date in date) is
1819: select object_version_number
1820: from per_all_people_f

Line 1820: from per_all_people_f

1816: -- per_all_people_f
1817: cursor per_applicant_rec(p_appl_person_id in number,
1818: p_appl_effective_date in date) is
1819: select object_version_number
1820: from per_all_people_f
1821: where person_id = p_appl_person_id
1822: and p_appl_effective_date between effective_start_date
1823: and effective_end_date;
1824:

Line 1852: select person_id,Global_name from per_all_people_f

1848: and effective_end_date;
1849:
1850: -- added cursor for Bug 11679239
1851: cursor csr_assignment_person is
1852: select person_id,Global_name from per_all_people_f
1853: where person_id in
1854: (select person_id from per_all_assignments_f
1855: where ASSIGNMENT_ID = p_assignment_id);
1856:

Line 1881: from per_all_people_f

1877:
1878: -- Bug Fix 3041328
1879: cursor csr_person is
1880: select person_id
1881: from per_all_people_f
1882: where person_id = p_supervisor_id;
1883:
1884: CURSOR lc_get_current_applicant_flag
1885: (p_person_id in number

Line 1891: FROM per_all_people_f per

1887: IS
1888: SELECT per.current_applicant_flag,
1889: per.current_employee_flag,
1890: per.current_npw_flag
1891: FROM per_all_people_f per
1892: WHERE per.person_id = p_person_id
1893: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
1894:
1895: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;

Line 1895: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;

1891: FROM per_all_people_f per
1892: WHERE per.person_id = p_person_id
1893: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
1894:
1895: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
1896: l_current_employee_flag per_all_people_f.current_employee_flag%type;
1897: l_current_npw_flag per_all_people_f.current_npw_flag%type;
1898: l_applicant_person_id per_all_people_f.person_id%type;
1899: l_applicant_assignment_id per_all_assignments_f.assignment_id%type;

Line 1896: l_current_employee_flag per_all_people_f.current_employee_flag%type;

1892: WHERE per.person_id = p_person_id
1893: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
1894:
1895: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
1896: l_current_employee_flag per_all_people_f.current_employee_flag%type;
1897: l_current_npw_flag per_all_people_f.current_npw_flag%type;
1898: l_applicant_person_id per_all_people_f.person_id%type;
1899: l_applicant_assignment_id per_all_assignments_f.assignment_id%type;
1900: l_applicant_effective_date per_all_people_f.effective_start_date%type;

Line 1897: l_current_npw_flag per_all_people_f.current_npw_flag%type;

1893: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date;
1894:
1895: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
1896: l_current_employee_flag per_all_people_f.current_employee_flag%type;
1897: l_current_npw_flag per_all_people_f.current_npw_flag%type;
1898: l_applicant_person_id per_all_people_f.person_id%type;
1899: l_applicant_assignment_id per_all_assignments_f.assignment_id%type;
1900: l_applicant_effective_date per_all_people_f.effective_start_date%type;
1901:

Line 1898: l_applicant_person_id per_all_people_f.person_id%type;

1894:
1895: l_current_applicant_flag per_all_people_f.current_applicant_flag%type;
1896: l_current_employee_flag per_all_people_f.current_employee_flag%type;
1897: l_current_npw_flag per_all_people_f.current_npw_flag%type;
1898: l_applicant_person_id per_all_people_f.person_id%type;
1899: l_applicant_assignment_id per_all_assignments_f.assignment_id%type;
1900: l_applicant_effective_date per_all_people_f.effective_start_date%type;
1901:
1902: -- Bug Fix 3041328

Line 1900: l_applicant_effective_date per_all_people_f.effective_start_date%type;

1896: l_current_employee_flag per_all_people_f.current_employee_flag%type;
1897: l_current_npw_flag per_all_people_f.current_npw_flag%type;
1898: l_applicant_person_id per_all_people_f.person_id%type;
1899: l_applicant_assignment_id per_all_assignments_f.assignment_id%type;
1900: l_applicant_effective_date per_all_people_f.effective_start_date%type;
1901:
1902: -- Bug Fix 3041328
1903: l_supervisor_id per_all_people_F.person_id%type;
1904: -- l_supervisor_assign_id per_all_assignments_f.assignment_id%type;

Line 1903: l_supervisor_id per_all_people_F.person_id%type;

1899: l_applicant_assignment_id per_all_assignments_f.assignment_id%type;
1900: l_applicant_effective_date per_all_people_f.effective_start_date%type;
1901:
1902: -- Bug Fix 3041328
1903: l_supervisor_id per_all_people_F.person_id%type;
1904: -- l_supervisor_assign_id per_all_assignments_f.assignment_id%type;
1905: l_supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type;
1906:
1907: l_re_hire_flow varchar2(25) default null;

Line 1911: select ppt.SYSTEM_PERSON_TYPE from per_all_people_f paf, per_person_types ppt where person_id = l_person_id

1907: l_re_hire_flow varchar2(25) default null;
1908: l_error_message varchar2(500);
1909: l_ex_emp varchar2(10) default null;
1910: CURSOR chk_ex_emp(l_person_id in number, l_effective_date in Date) is
1911: select ppt.SYSTEM_PERSON_TYPE from per_all_people_f paf, per_person_types ppt where person_id = l_person_id
1912: and paf.PERSON_TYPE_ID = ppt.PERSON_TYPE_ID
1913: and l_effective_date between effective_start_date and effective_end_date;
1914:
1915: l_proc constant varchar2(100) := g_package || ' update_asg';

Line 2073: -- per_all_people_f

2069: itemtype => p_item_type,
2070: itemkey => p_item_key,
2071: aname => 'CURRENT_EFFECTIVE_DATE');
2072: -- first get the object_version_number for the applicant from
2073: -- per_all_people_f
2074:
2075: open per_applicant_rec(l_person_id, l_applicant_effective_date);
2076: fetch per_applicant_rec into l_per_object_version_number;
2077: close per_applicant_rec;

Line 2090: -- per_all_people_f

2086: p_item_type => p_item_type
2087: ,p_item_key => p_item_key
2088: ,p_employee_number => l_employee_number);
2089: -- first get the object_version_number for the applicant from
2090: -- per_all_people_f
2091:
2092: open per_applicant_rec(l_applicant_person_id, l_applicant_effective_date);
2093: fetch per_applicant_rec into l_per_object_version_number;
2094: close per_applicant_rec;