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

Line 111: ,per_assignments_f ass

107: IS
108: SELECT distinct ass.assignment_id
109: ,ass.establishment_id
110: FROM pay_payroll_actions bppa
111: ,per_assignments_f ass
112: ,hr_organization_information hoi
113: ,hr_organization_units hou
114: WHERE bppa.payroll_action_id = p_payroll_action_id
115: AND ass.person_id BETWEEN p_start_person_id AND p_end_person_id

Line 272: FROM per_assignments_f pa,

268: IS
269: SELECT paa.assignment_id,
270: pa.payroll_id,
271: pa.establishment_id -- Bug 3506172
272: FROM per_assignments_f pa,
273: pay_assignment_actions paa
274: WHERE paa.assignment_action_id = p_assignment_action_id
275: AND pa.assignment_id = paa.assignment_id
276: AND g_pact.effective_date BETWEEN pa.effective_start_date AND pa.effective_end_date;

Line 286: ,per_assignments_f ass

282: ,pp.national_identifier registration_code
283: ,hoi.org_information2 branch_code
284: ,hoi1.org_information14 computerization_code
285: FROM pay_assignment_actions paa
286: ,per_assignments_f ass
287: ,per_people_f pp
288: ,hr_organization_information hoi
289: ,hr_organization_information hoi1
290: WHERE paa.assignment_action_id = p_assignment_action_id