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.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PER_ALL_PEOPLE_F

Line 94: FROM per_All_people_f

90: --
91: CURSOR csr_get_person_name(cperson_id NUMBER
92: ,ceffective_date DATE) IS
93: SELECT full_name
94: FROM per_All_people_f
95: WHERE person_id = cperson_id
96: AND ceffective_date BETWEEN effective_start_date AND effective_end_date;
97: --
98: leffective_date DATE;

Line 102: lperson_id per_all_people_f.person_id%TYPE;

98: leffective_date DATE;
99: lreporting_date DATE;
100: lpayroll_id pay_all_payrolls_f.payroll_id%TYPE;
101: lassignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
102: lperson_id per_all_people_f.person_id%TYPE;
103: lpayroll_name pay_all_payrolls_f.payroll_name%TYPE;
104: lreturn_val VARCHAR2(400);
105: lfull_name per_all_people_f.full_name%TYPE;
106: lbusiness_group_id per_all_people_f.business_group_id%TYPE;

Line 105: lfull_name per_all_people_f.full_name%TYPE;

101: lassignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
102: lperson_id per_all_people_f.person_id%TYPE;
103: lpayroll_name pay_all_payrolls_f.payroll_name%TYPE;
104: lreturn_val VARCHAR2(400);
105: lfull_name per_all_people_f.full_name%TYPE;
106: lbusiness_group_id per_all_people_f.business_group_id%TYPE;
107: BEGIN
108: --
109: per_hu_abs_rep_archive_pkg.get_all_parameters (

Line 106: lbusiness_group_id per_all_people_f.business_group_id%TYPE;

102: lperson_id per_all_people_f.person_id%TYPE;
103: lpayroll_name pay_all_payrolls_f.payroll_name%TYPE;
104: lreturn_val VARCHAR2(400);
105: lfull_name per_all_people_f.full_name%TYPE;
106: lbusiness_group_id per_all_people_f.business_group_id%TYPE;
107: BEGIN
108: --
109: per_hu_abs_rep_archive_pkg.get_all_parameters (
110: p_payroll_action_id => p_actid

Line 161: l_emp_id per_all_people_f.person_id%TYPE;

157: AND pui.effective_end_date
158: AND pui.value LIKE 'HU%';
159:
160: l_effective_date DATE;
161: l_emp_id per_all_people_f.person_id%TYPE;
162: l_exsist NUMBER;
163: BEGIN
164: --
165: per_hu_abs_rep_archive_pkg.get_all_parameters (

Line 230: ,per_all_people_f pap

226: ,paa.payroll_id payroll_id
227: ,paa.job_id job_id
228: FROM pay_payroll_actions ppa
229: ,per_all_assignments_f paa
230: ,per_all_people_f pap
231: ,per_periods_of_service ppf
232: ,hr_organization_information hoi
233: ,hr_all_organization_units hou
234: WHERE ppa.payroll_action_id = c_pact_id

Line 347: l_emp_id per_all_people_f.person_id%TYPE;

343:
344: l_actid NUMBER;
345: l_action_info_id pay_action_information.action_information_id%TYPE;
346: l_ovn pay_action_information.object_version_NUMBER%TYPE;
347: l_emp_id per_all_people_f.person_id%TYPE;
348: l_sort_1 VARCHAR2(30);
349: l_sort_2 VARCHAR2(30);
350: l_incl_excl NUMBER;
351: l_effective_date DATE;

Line 942: ,per_all_people_f pap

938: --
939: CURSOR csr_child_less_then_16 is
940: SELECT count(*)
941: FROM PER_CONTACT_RELATIONSHIPS pcr
942: ,per_all_people_f pap
943: ,per_all_assignments_f paa
944: WHERE pcr.person_id = paa.person_id
945: AND pap.business_group_id = p_business_group_id
946: AND pcr.business_group_id = p_business_group_id

Line 960: ,per_all_people_f pap

956: --
957: CURSOR csr_child_16 is
958: SELECT count(*)
959: FROM PER_CONTACT_RELATIONSHIPS pcr
960: ,per_all_people_f pap
961: ,per_all_assignments_f paa
962: WHERE pcr.person_id = paa.person_id
963: AND pap.business_group_id = p_business_group_id
964: AND pcr.business_group_id = p_business_group_id

Line 980: ,per_all_people_f pap

976: --
977: CURSOR csr_child_16_dob is
978: SELECT pap.date_of_birth dob
979: FROM per_contact_relationships pcr
980: ,per_all_people_f pap
981: ,per_all_assignments_f paa
982: WHERE pcr.person_id = paa.person_id
983: AND pap.business_group_id = p_business_group_id
984: AND pcr.business_group_id = p_business_group_id

Line 1107: FROM per_all_people_f pap

1103: (p_assignment_id IN NUMBER
1104: ,p_calculation_date IN date ) RETURN Date is
1105: CURSOR csr_person_dob IS
1106: SELECT pap.date_of_birth
1107: FROM per_all_people_f pap
1108: ,per_all_assignments_f paa
1109: WHERE paa.assignment_id = p_assignment_id
1110: AND paa.person_id = pap.person_id
1111: AND p_calculation_date

Line 1173: FROM per_disabilities_f pdf ,per_all_people_f papf, per_all_assignments_f paaf

1169: ,p_period_start_date DATE
1170: ,p_period_end_date DATE) RETURN NUMBER IS
1171: CURSOR csr_disability is
1172: SELECT pdf.effective_start_date,pdf.effective_end_date
1173: FROM per_disabilities_f pdf ,per_all_people_f papf, per_all_assignments_f paaf
1174: WHERE paaf.assignment_id=p_assignment_id
1175: AND paaf.business_group_id=p_business_group_id
1176: AND paaf.person_id=papf.person_id
1177: AND papf.person_id=pdf.person_id