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.PQP_ALIEN_EXPAT_WF_PKG dependencies on PER_ASSIGNMENTS_F

Line 69: ,per_assignments_f paf

65: -- Get HR/ Payroll Contact User Name
66: cursor csr_payroll_contact is
67: select prl.prl_information1
68: from pay_payrolls_f prl
69: ,per_assignments_f paf
70: where prl.payroll_id = paf.payroll_id
71: and prl.prl_information_category = 'US'
72: and paf.assignment_id = l_assignment_id
73: and trunc(p_tran_date) between prl.effective_start_date

Line 82: from per_assignments_f paf

78: from hr_organization_information org
79: where org.org_information_context = 'Contact Information'
80: and org.organization_id = (
81: select hsc.segment1
82: from per_assignments_f paf
83: ,hr_soft_coding_keyflex hsc
84: where hsc.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
85: and paf.assignment_id = l_assignment_id
86: and trunc(p_tran_date) between paf.effective_start_date and