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_EMP_CERT_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 364: ,hr_soft_coding_keyflex hr

360: FROM per_all_people_F pap
361: ,per_periods_of_service ppf
362: ,per_all_assignments_f paa
363: ,pay_assignment_actions paas
364: ,hr_soft_coding_keyflex hr
365: ,hr_organization_information hoi
366: WHERE paas.assignment_action_id = p_assactid
367: AND paas.assignment_id = paa.assignment_id
368: AND pap.person_id = ppf.person_id

Line 374: AND paa.soft_coding_keyflex_id = hr.soft_coding_keyflex_id (+)

370: AND pap.person_id = paa.person_id
371: AND paa.period_of_service_id = ppf.period_of_service_id
372: AND hoi.organization_id = paa.business_group_id
373: AND hoi.org_information_context = 'HU_COMPANY_INFORMATION_DETAILS'
374: AND paa.soft_coding_keyflex_id = hr.soft_coding_keyflex_id (+)
375: AND ppf.actual_termination_date BETWEEN pap.effective_start_date
376: AND pap.effective_end_date
377: AND ppf.actual_termination_date BETWEEN paa.effective_start_date
378: AND paa.effective_end_date;