APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 229: ,per_all_assignments_f paa

225: ,paa.location_id location_id
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

Line 293: ,per_all_assignments_f paa

289: CURSOR csr_incl_excl(c_assignment_id NUMBER
290: ,c_assignment_set_id NUMBER) IS
291: SELECT 1
292: FROM hr_assignment_sets has
293: ,per_all_assignments_f paa
294: WHERE has.assignment_set_id = NVL(c_assignment_set_id, has.assignment_set_id)
295: AND paa.assignment_id = c_assignment_id
296: AND NVL(paa.payroll_id,0) = NVL(has.payroll_id,NVL(paa.payroll_id,0))
297: AND NOT EXISTS

Line 334: FROM per_all_assignments_f paa

330: --
331: CURSOR suspended_asg_end_dt(c_assignment_id NUMBER
332: ,c_reporting_date DATE ) IS
333: SELECT MAX(paa.effective_end_date)
334: FROM per_all_assignments_f paa
335: ,per_assignment_status_types pas
336: WHERE paa.assignment_id = c_assignment_id
337: AND pas.assignment_status_type_id = paa.assignment_status_type_id
338: AND pas.per_system_status = 'SUSP_ASSIGN'

Line 943: ,per_all_assignments_f paa

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
947: AND pcr.cont_information3 = 'Y'

Line 961: ,per_all_assignments_f paa

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
965: AND pcr.cont_information3 = 'Y'

Line 981: ,per_all_assignments_f paa

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
985: AND pcr.cont_information3 = 'Y'

Line 1108: ,per_all_assignments_f paa

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
1112: BETWEEN paa.effective_start_date

Line 1142: SELECT person_id FROM per_All_assignments_f

1138: AND to_char(end_date,'YYYY') = p_termination_year
1139: ORDER BY end_date DESC;
1140:
1141: CURSOR csr_get_person_id IS
1142: SELECT person_id FROM per_All_assignments_f
1143: WHERE assignment_id = p_assignment_id;
1144:
1145: l_sickness_leave NUMBER;
1146: l_person_id NUMBER;

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

Line 1234: FROM per_all_assignments_f paaf,per_jobs pj

1230: ,p_period_start_date DATE
1231: ,p_period_end_date DATE) RETURN NUMBER is
1232: CURSOR csr_job is
1233: SELECT paaf.effective_start_date,paaf.effective_end_date,pj.date_to
1234: FROM per_all_assignments_f paaf,per_jobs pj
1235: WHERE paaf.assignment_id=p_assignment_id
1236: AND paaf.business_group_id=p_business_group_id
1237: AND paaf.job_id=pj.job_id
1238: AND pj.job_information3='Y'