APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 67: FROM hr_organization_information hoi1

63: ,hoi2.org_information1 company_name
64: ,hoi2.org_information3 representative_title
65: ,hoi2.org_information8 cac
66: ,hoi2.org_information2 person_id
67: FROM hr_organization_information hoi1
68: ,hr_All_organization_units hou
69: ,hr_organization_information hoi2
70: WHERE hou.business_group_id = c_business_group_id
71: AND hoi1.organization_id = hou.organization_id

Line 69: ,hr_organization_information hoi2

65: ,hoi2.org_information8 cac
66: ,hoi2.org_information2 person_id
67: FROM hr_organization_information hoi1
68: ,hr_All_organization_units hou
69: ,hr_organization_information hoi2
70: WHERE hou.business_group_id = c_business_group_id
71: AND hoi1.organization_id = hou.organization_id
72: AND hoi2.organization_id = hou.organization_id
73: AND hou.organization_id = NVL(c_legal_employer,hou.organization_id)

Line 175: ,hr_organization_information hoi

171: SELECT assignment_id
172: FROM per_all_assignments_f asl
173: ,per_periods_of_service ppos
174: ,hr_soft_coding_keyflex hr
175: ,hr_organization_information hoi
176: WHERE asl.person_id BETWEEN stperson AND endperson
177: AND asl.primary_flag = 'Y'
178: AND ppos.period_of_service_id = asl.period_of_service_id
179: AND ppos.actual_termination_date BETWEEN c_start_date AND c_end_date

Line 210: ,hr_organization_information hoi

206: ,c_business_group_id NUMBER) IS
207: SELECT assignment_id
208: FROM per_all_assignments_f asl
209: ,hr_soft_coding_keyflex hr
210: ,hr_organization_information hoi
211: ,per_absence_attendance_types pat
212: ,per_absence_attendances paa
213: ,pay_payroll_actions ppa
214: where ppa.payroll_action_id = c_p_actid

Line 478: ,hr_organization_information hoi

474: ,per_periods_of_service pps
475: ,pay_assignment_actions paas
476: ,pay_payroll_actions ppa
477: ,hr_soft_coding_keyflex hr
478: ,hr_organization_information hoi
479: WHERE paas.assignment_action_id = p_assactid
480: AND paas.payroll_action_id = ppa.payroll_action_id
481: AND paa.assignment_id = paas.assignment_id
482: AND pap.person_id = paa.person_id

Line 526: ,hr_organization_information hoi

522: ,pay_assignment_actions paas
523: ,pay_payroll_actions ppa
524: ,per_periods_of_service pps
525: ,hr_soft_coding_keyflex hr
526: ,hr_organization_information hoi
527: ,per_absence_attendance_types pat
528: ,per_absence_attendances paat
529: WHERE paas.assignment_action_id = p_assactid
530: AND paas.payroll_action_id = ppa.payroll_action_id