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_CA_T4A_REG dependencies on PER_ASSIGNMENTS_F

Line 161: per_assignments_f paf,

157: paa.assignment_action_id,
158: paa.payroll_action_id,
159: paf.effective_end_date
160: from
161: per_assignments_f paf,
162: pay_assignment_actions paa
163: where
164: paf.person_id >= stperson and
165: paf.person_id <= endperson and

Line 170: from per_assignments_f paf2

166: paf.primary_flag = 'Y' and
167: paf.assignment_type = 'E' and
168: paf.business_group_id = l_bus_group_id and
169: paf.effective_start_date = (select max(paf2.effective_start_date)
170: from per_assignments_f paf2
171: where paf2.assignment_id= paf.assignment_id
172: and paf2.primary_flag = 'Y'
173: and paf2.effective_start_date
174: <= l_session_date) and --l_year_end

Line 188: per_assignments_f paf,

184: paa.assignment_action_id,
185: paa.payroll_action_id,
186: paf.effective_end_date
187: from
188: per_assignments_f paf,
189: pay_assignment_actions paa,
190: pay_population_ranges ppr
191: where
192: -- paf.person_id >= stperson and

Line 201: from per_assignments_f paf2

197: paf.primary_flag = 'Y' and
198: paf.assignment_type = 'E' and
199: paf.business_group_id = l_bus_group_id and
200: paf.effective_start_date = (select max(paf2.effective_start_date)
201: from per_assignments_f paf2
202: where paf2.assignment_id= paf.assignment_id
203: and paf2.primary_flag = 'Y'
204: and paf2.effective_start_date
205: <= l_session_date) and --l_year_end

Line 219: per_assignments_f paf,

215: paa.assignment_action_id,
216: paa.payroll_action_id,
217: paf.effective_end_date
218: from
219: per_assignments_f paf,
220: pay_assignment_actions paa,
221: per_periods_of_service PDS
222: where
223: paf.person_id >= stperson and

Line 229: from per_assignments_f paf2

225: paf.primary_flag = 'Y' and
226: paf.assignment_type = 'E' and
227: paf.business_group_id = l_bus_group_id and
228: paf.effective_start_date = (select max(paf2.effective_start_date)
229: from per_assignments_f paf2
230: where paf2.assignment_id= paf.assignment_id
231: and paf2.primary_flag = 'Y'
232: and paf2.effective_start_date
233: <= l_session_date) and --l_year_end

Line 247: per_assignments_f paf,

243: paa.assignment_action_id,
244: paa.payroll_action_id,
245: paf.effective_end_date
246: from
247: per_assignments_f paf,
248: pay_assignment_actions paa,
249: pay_population_ranges ppr,
250: per_periods_of_service PDS
251: where

Line 261: from per_assignments_f paf2

257: paf.primary_flag = 'Y' and
258: paf.assignment_type = 'E' and
259: paf.business_group_id = l_bus_group_id and
260: paf.effective_start_date = (select max(paf2.effective_start_date)
261: from per_assignments_f paf2
262: where paf2.assignment_id= paf.assignment_id
263: and paf2.primary_flag = 'Y'
264: and paf2.effective_start_date
265: <= l_session_date) and --l_year_end

Line 281: from per_assignments_f paf,

277: select paf.assignment_id assignment_id,
278: paa.assignment_action_id,
279: paa.payroll_action_id,
280: paf.effective_end_date
281: from per_assignments_f paf,
282: pay_assignment_actions paa
283: where paf.person_id between stperson
284: and endperson
285: and paf.primary_flag = 'Y'

Line 289: from per_assignments_f paf2

285: and paf.primary_flag = 'Y'
286: and paf.assignment_type = 'E'
287: and paf.business_group_id = l_bus_group_id
288: and paf.effective_start_date = (select max(paf2.effective_start_date)
289: from per_assignments_f paf2
290: where paf2.assignment_id= paf.assignment_id
291: and paf2.primary_flag = 'Y'
292: and paf2.effective_start_date
293: <= l_session_date)

Line 306: from per_assignments_f paf,

302: select paf.assignment_id assignment_id,
303: paa.assignment_action_id,
304: paa.payroll_action_id,
305: paf.effective_end_date
306: from per_assignments_f paf,
307: pay_assignment_actions paa,
308: per_periods_of_service pds
309: where paf.person_id between stperson
310: and endperson

Line 315: from per_assignments_f paf2

311: and paf.primary_flag = 'Y'
312: and paf.assignment_type = 'E'
313: and paf.business_group_id = l_bus_group_id
314: and paf.effective_start_date = (select max(paf2.effective_start_date)
315: from per_assignments_f paf2
316: where paf2.assignment_id= paf.assignment_id
317: and paf2.primary_flag = 'Y'
318: and paf2.effective_start_date
319: <= l_session_date)

Line 338: per_assignments_f paf,

334: paa.assignment_action_id,
335: paa.payroll_action_id,
336: paf.effective_end_date
337: from
338: per_assignments_f paf,
339: pay_assignment_actions paa
340: where
341: paf.person_id >= stperson and
342: paf.person_id <= endperson and

Line 347: from per_assignments_f paf2

343: paf.primary_flag = 'Y' and
344: paf.assignment_type = 'E' and
345: paf.business_group_id = l_bus_group_id and
346: paf.effective_start_date = (select max(paf2.effective_start_date)
347: from per_assignments_f paf2
348: where paf2.assignment_id= paf.assignment_id
349: and paf2.primary_flag = 'Y'
350: and paf2.effective_start_date
351: <= l_session_date) and --l_year_end

Line 368: per_assignments_f paf,

364: paa.assignment_action_id,
365: paa.payroll_action_id,
366: paf.effective_end_date
367: from
368: per_assignments_f paf,
369: pay_assignment_actions paa,
370: pay_population_ranges ppr
371: where
372: -- paf.person_id >= stperson and

Line 381: from per_assignments_f paf2

377: paf.primary_flag = 'Y' and
378: paf.assignment_type = 'E' and
379: paf.business_group_id = l_bus_group_id and
380: paf.effective_start_date = (select max(paf2.effective_start_date)
381: from per_assignments_f paf2
382: where paf2.assignment_id= paf.assignment_id
383: and paf2.primary_flag = 'Y'
384: and paf2.effective_start_date
385: <= l_session_date) and --l_year_end

Line 404: per_assignments_f paf,

400: paa.assignment_action_id,
401: paa.payroll_action_id,
402: paf.effective_end_date
403: from
404: per_assignments_f paf,
405: pay_assignment_actions paa,
406: per_periods_of_service pds
407: where
408: paf.person_id >= stperson and

Line 414: from per_assignments_f paf2

410: paf.primary_flag = 'Y' and
411: paf.assignment_type = 'E' and
412: paf.business_group_id = l_bus_group_id and
413: paf.effective_start_date = (select max(paf2.effective_start_date)
414: from per_assignments_f paf2
415: where paf2.assignment_id= paf.assignment_id
416: and paf2.primary_flag = 'Y'
417: and paf2.effective_start_date
418: <= l_session_date) and --l_year_end

Line 437: per_assignments_f paf,

433: paa.assignment_action_id,
434: paa.payroll_action_id,
435: paf.effective_end_date
436: from
437: per_assignments_f paf,
438: pay_assignment_actions paa,
439: pay_population_ranges ppr,
440: per_periods_of_service pds
441: where

Line 451: from per_assignments_f paf2

447: paf.primary_flag = 'Y' and
448: paf.assignment_type = 'E' and
449: paf.business_group_id = l_bus_group_id and
450: paf.effective_start_date = (select max(paf2.effective_start_date)
451: from per_assignments_f paf2
452: where paf2.assignment_id= paf.assignment_id
453: and paf2.primary_flag = 'Y'
454: and paf2.effective_start_date
455: <= l_session_date) and --l_year_end