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_JP_ID_PKG dependencies on PER_ALL_PEOPLE_F

Line 868: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE

864: FUNCTION emp_person_rec(
865: p_employee_number IN VARCHAR2,
866: p_business_group_id IN NUMBER,
867: p_effective_date IN DATE DEFAULT hr_api.g_sys,
868: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE
869: --------------------------------------------------------------------------------
870: IS
871: l_csr RefCsr;
872: l_rec PER_ALL_PEOPLE_F%ROWTYPE;

Line 872: l_rec PER_ALL_PEOPLE_F%ROWTYPE;

868: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE
869: --------------------------------------------------------------------------------
870: IS
871: l_csr RefCsr;
872: l_rec PER_ALL_PEOPLE_F%ROWTYPE;
873: BEGIN
874: l_csr := csr_with_bus('PER_ALL_PEOPLE_F','EMPLOYEE_NUMBER','T',p_employee_number,p_business_group_id,'DATETRACKED',p_effective_date);
875: fetch l_csr into l_rec;
876: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 874: l_csr := csr_with_bus('PER_ALL_PEOPLE_F','EMPLOYEE_NUMBER','T',p_employee_number,p_business_group_id,'DATETRACKED',p_effective_date);

870: IS
871: l_csr RefCsr;
872: l_rec PER_ALL_PEOPLE_F%ROWTYPE;
873: BEGIN
874: l_csr := csr_with_bus('PER_ALL_PEOPLE_F','EMPLOYEE_NUMBER','T',p_employee_number,p_business_group_id,'DATETRACKED',p_effective_date);
875: fetch l_csr into l_rec;
876: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
877: l_rec := NULL;
878: end if;

Line 897: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE

893: FUNCTION apl_person_rec(
894: p_applicant_number IN VARCHAR2,
895: p_business_group_id IN NUMBER,
896: p_effective_date IN DATE DEFAULT hr_api.g_sys,
897: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE
898: --------------------------------------------------------------------------------
899: IS
900: l_csr RefCsr;
901: l_rec PER_ALL_PEOPLE_F%ROWTYPE;

Line 901: l_rec PER_ALL_PEOPLE_F%ROWTYPE;

897: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_ALL_PEOPLE_F%ROWTYPE
898: --------------------------------------------------------------------------------
899: IS
900: l_csr RefCsr;
901: l_rec PER_ALL_PEOPLE_F%ROWTYPE;
902: BEGIN
903: l_csr := csr_with_bus('PER_ALL_PEOPLE_F','APPLICANT_NUMBER','T',p_applicant_number,p_business_group_id,'DATETRACKED',p_effective_date);
904: fetch l_csr into l_rec;
905: if not csr_found_and_close(l_csr,p_error_when_not_exist) then

Line 903: l_csr := csr_with_bus('PER_ALL_PEOPLE_F','APPLICANT_NUMBER','T',p_applicant_number,p_business_group_id,'DATETRACKED',p_effective_date);

899: IS
900: l_csr RefCsr;
901: l_rec PER_ALL_PEOPLE_F%ROWTYPE;
902: BEGIN
903: l_csr := csr_with_bus('PER_ALL_PEOPLE_F','APPLICANT_NUMBER','T',p_applicant_number,p_business_group_id,'DATETRACKED',p_effective_date);
904: fetch l_csr into l_rec;
905: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
906: l_rec := NULL;
907: end if;

Line 1871: per_all_people_f pp

1867: l_rec PER_PERIODS_OF_SERVICE%ROWTYPE;
1868: CURSOR csr_period_of_service IS
1869: select pps.*
1870: from per_periods_of_service pps,
1871: per_all_people_f pp
1872: where pp.employee_number=p_employee_number
1873: and pp.business_group_id=p_business_group_id
1874: and p_effective_date
1875: between pp.effective_start_date and pp.effective_end_date