APPS.PER_ES_COMP_CERT_ARCHIVE_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 174: ,hr_soft_coding_keyflex hr

170: ,c_business_group_id NUMBER) IS
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

Line 182: AND hr.soft_coding_keyflex_id = asl.soft_coding_keyflex_id

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
180: AND asl.effective_end_date = ppos.actual_termination_date
181: AND asl.business_group_id = c_business_group_id
182: AND hr.soft_coding_keyflex_id = asl.soft_coding_keyflex_id
183: AND hr.segment2 = hoi.org_information1
184: AND hoi.org_information_context = 'ES_WORK_CENTER_REF'
185: AND hoi.organization_id = decode(c_legal_employer,NULL,hoi.organization_id,c_legal_employer)
186: AND NOT EXISTS (SELECT /*+ ORDERED */ NULL

Line 209: ,hr_soft_coding_keyflex hr

205: ,c_end_date DATE
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

Line 224: AND hr.soft_coding_keyflex_id = asl.soft_coding_keyflex_id

220: AND pat.absence_category = 'TD'
221: AND pat.business_group_id = ppa.business_group_id
222: AND paa.business_group_id = ppa.business_group_id
223: AND paa.date_start between c_start_date AND c_end_date
224: AND hr.soft_coding_keyflex_id = asl.soft_coding_keyflex_id
225: AND hr.segment2 = hoi.org_information1
226: AND hoi.org_information_context = 'ES_WORK_CENTER_REF'
227: AND hoi.organization_id =NVL(c_legal_employer,hoi.organization_id)
228: AND c_end_date between asl.effective_start_date and asl.effective_end_date

Line 477: ,hr_soft_coding_keyflex hr

473: ,per_all_assignments_f paa
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

Line 485: AND hr.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

481: AND paa.assignment_id = paas.assignment_id
482: AND pap.person_id = paa.person_id
483: AND pap.person_id = pps.person_id
484: AND pps.period_of_service_id = paa.period_of_service_id
485: AND hr.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
486: AND hr.segment2 = hoi.org_information1
487: AND hoi.org_information_context = 'ES_WORK_CENTER_REF'
488: AND pps.actual_termination_date BETWEEN ppa.start_date
489: AND ppa.effective_date

Line 525: ,hr_soft_coding_keyflex hr

521: ,per_all_assignments_f paa
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

Line 543: AND hr.soft_coding_keyflex_id = paa.soft_coding_keyflex_id

539: AND paa.effective_start_date = (select max(paaf.effective_start_date)
540: from per_all_assignments_f paaf
541: where paaf.assignment_id = paa.Assignment_id
542: AND paaf.effective_start_date <= ppa.effective_date)
543: AND hr.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
544: AND hr.segment2 = hoi.org_information1
545: AND hoi.org_information_context = 'ES_WORK_CENTER_REF'
546: AND pat.ABSENCE_ATTENDANCE_TYPE_ID = paat.ABSENCE_ATTENDANCE_TYPE_ID
547: AND pat.ABSENCE_CATEGORY = 'TD'