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_SOE_GLB dependencies on PER_ALL_ASSIGNMENTS_F

Line 165: from per_all_assignments_f

161: ------------------------------------------------------------------------ */
162: function setParameters(p_person_id in number, p_assignment_id in number, p_effective_date date) return varchar2 is
163: cursor csr_get_asg_id is
164: select assignment_id
165: from per_all_assignments_f
166: where person_id = p_person_id
167: and p_effective_date between effective_start_date and effective_end_date;
168:
169: cursor csr_get_action_id (asg_id number) is

Line 236: ,per_all_assignments_f asg

232: ,hl.meaning COL11
233: ,assignment_number COL12
234: ,nvl(ppb1.salary,''0'') COL13
235: from per_all_people_f peo
236: ,per_all_assignments_f asg
237: ,hr_all_organization_units_vl org
238: ,per_jobs_vl job
239: ,per_all_positions pos
240: ,hr_locations loc