APPS.PAY_SE_TRNA_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 396: hr_soft_coding_keyflex hsck,

392: ) IS
393: SELECT papf.person_id, paaf.assignment_id, papf.full_name, papf.national_identifier, paaf.assignment_number,
394: paaf.employment_category, hsck.segment15 div_code, hsck.segment14 area_code
395: FROM per_all_assignments_f paaf,
396: hr_soft_coding_keyflex hsck,
397: hr_organization_units hou,
398: hr_organization_information hoi,
399: per_all_people_f papf
400: WHERE papf.person_id BETWEEN p_start_person AND p_end_person

Line 421: FROM hr_soft_coding_keyflex hs

417: AND hoi.organization_id = nvl (p_legal_employer_id, hoi.organization_id)
418: AND hoi.org_information_context = 'SE_LOCAL_UNITS'
419: AND hoi.org_information1 = hsck.segment2
420: AND (SELECT nvl(fnd_date.canonical_to_date (hs.segment16),TO_DATE ('01/01/0001', 'dd/mm/yyyy'))
421: FROM hr_soft_coding_keyflex hs
422: WHERE hs.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id) <= nvl (
423: g_precedence_end_date,
424: TO_DATE ('31/12/4712', 'dd/mm/yyyy')
425: ); -- Inner Query for 7162312

Line 450: FROM per_all_assignments_f paaf, hr_soft_coding_keyflex hsck

446: ) IS
447: SELECT fnd_date.canonical_to_date (hsck.segment6) termination_date,
448: fnd_date.canonical_to_date (hsck.segment16)
449: precedence_date
450: FROM per_all_assignments_f paaf, hr_soft_coding_keyflex hsck
451: WHERE paaf.assignment_id = p_assignment_id
452: AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
453: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date;
454: