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

Line 186: from per_assignments_f paf,

182: faic.context prov_cd,
183: paa.assignment_action_id,
184: paa.payroll_action_id,
185: paf.effective_end_date
186: from per_assignments_f paf,
187: pay_assignment_actions paa,
188: ff_archive_items fai,
189: ff_contexts fc,
190: ff_archive_item_contexts faic

Line 195: from per_assignments_f paf2

191: where paf.person_id between stperson
192: and endperson
193: and paf.primary_flag = 'Y'
194: and paf.effective_start_date = (select max(paf2.effective_start_date)
195: from per_assignments_f paf2
196: where paf2.assignment_id= paf.assignment_id
197: and paf2.primary_flag = 'Y'
198: and paf2.effective_start_date
199: <= l_session_date) --l_year_end

Line 220: from per_assignments_f paf,

216: faic.context prov_cd,
217: paa.assignment_action_id,
218: paa.payroll_action_id,
219: paf.effective_end_date
220: from per_assignments_f paf,
221: pay_assignment_actions paa,
222: ff_archive_items fai,
223: ff_contexts fc,
224: ff_archive_item_contexts faic,

Line 230: from per_assignments_f paf2

226: where --paf.person_id between stperson
227: -- and endperson
228: paf.primary_flag = 'Y'
229: and paf.effective_start_date = (select max(paf2.effective_start_date)
230: from per_assignments_f paf2
231: where paf2.assignment_id= paf.assignment_id
232: and paf2.primary_flag = 'Y'
233: and paf2.effective_start_date
234: <= l_session_date) --l_year_end

Line 257: from per_assignments_f paf,

253: faic.context prov_cd,
254: paa.assignment_action_id,
255: paa.payroll_action_id,
256: paf.effective_end_date
257: from per_assignments_f paf,
258: pay_assignment_actions paa,
259: ff_archive_items fai,
260: ff_contexts fc,
261: ff_archive_item_contexts faic,

Line 267: from per_assignments_f paf2

263: where paf.person_id between stperson
264: and endperson
265: and paf.primary_flag = 'Y'
266: and paf.effective_start_date = (select max(paf2.effective_start_date)
267: from per_assignments_f paf2
268: where paf2.assignment_id= paf.assignment_id
269: and paf2.primary_flag = 'Y'
270: and paf2.effective_start_date
271: <= l_session_date) --l_year_end

Line 292: from per_assignments_f paf,

288: faic.context prov_cd,
289: paa.assignment_action_id,
290: paa.payroll_action_id,
291: paf.effective_end_date
292: from per_assignments_f paf,
293: pay_assignment_actions paa,
294: ff_archive_items fai,
295: ff_contexts fc,
296: ff_archive_item_contexts faic,

Line 303: from per_assignments_f paf2

299: where --paf.person_id between stperson
300: -- and endperson
301: paf.primary_flag = 'Y'
302: and paf.effective_start_date = (select max(paf2.effective_start_date)
303: from per_assignments_f paf2
304: where paf2.assignment_id= paf.assignment_id
305: and paf2.primary_flag = 'Y'
306: and paf2.effective_start_date
307: <= l_session_date) --l_year_end

Line 334: from per_assignments_f paf,

330: faic.context prov_cd,
331: paa.assignment_action_id,
332: paa.payroll_action_id,
333: paf.effective_end_date
334: from per_assignments_f paf,
335: pay_assignment_actions paa,
336: ff_archive_items fai,
337: ff_contexts fc,
338: ff_archive_item_contexts faic

Line 343: from per_assignments_f paf2

339: where paf.person_id between stperson
340: and endperson
341: and paf.primary_flag = 'Y'
342: and paf.effective_start_date = (select max(paf2.effective_start_date)
343: from per_assignments_f paf2
344: where paf2.assignment_id= paf.assignment_id
345: and paf2.primary_flag = 'Y'
346: and paf2.effective_start_date
347: <= l_session_date) --l_year_end

Line 370: from per_assignments_f paf,

366: faic.context prov_cd,
367: paa.assignment_action_id,
368: paa.payroll_action_id,
369: paf.effective_end_date
370: from per_assignments_f paf,
371: pay_assignment_actions paa,
372: ff_archive_items fai,
373: ff_contexts fc,
374: ff_archive_item_contexts faic,

Line 380: from per_assignments_f paf2

376: where paf.person_id between stperson
377: and endperson
378: and paf.primary_flag = 'Y'
379: and paf.effective_start_date = (select max(paf2.effective_start_date)
380: from per_assignments_f paf2
381: where paf2.assignment_id= paf.assignment_id
382: and paf2.primary_flag = 'Y'
383: and paf2.effective_start_date
384: <= l_session_date) --l_year_end

Line 410: from per_assignments_f paf,

406: faic.context prov_cd,
407: paa.assignment_action_id,
408: paa.payroll_action_id,
409: paf.effective_end_date
410: from per_assignments_f paf,
411: pay_assignment_actions paa,
412: ff_archive_items fai,
413: ff_archive_item_contexts faic,
414: ff_contexts fc

Line 419: from per_assignments_f paf2

415: where paf.person_id >= stperson
416: and paf.person_id <= endperson
417: and paf.primary_flag = 'Y'
418: and paf.effective_start_date = (select max(paf2.effective_start_date)
419: from per_assignments_f paf2
420: where paf2.assignment_id= paf.assignment_id
421: and paf2.primary_flag = 'Y'
422: and paf2.effective_start_date
423: <= l_session_date) --l_year_end

Line 448: from per_assignments_f paf,

444: faic.context prov_cd,
445: paa.assignment_action_id,
446: paa.payroll_action_id,
447: paf.effective_end_date
448: from per_assignments_f paf,
449: pay_assignment_actions paa,
450: ff_archive_items fai,
451: ff_archive_item_contexts faic,
452: ff_contexts fc,

Line 458: from per_assignments_f paf2

454: where --paf.person_id >= stperson
455: --and paf.person_id <= endperson
456: paf.primary_flag = 'Y'
457: and paf.effective_start_date = (select max(paf2.effective_start_date)
458: from per_assignments_f paf2
459: where paf2.assignment_id= paf.assignment_id
460: and paf2.primary_flag = 'Y'
461: and paf2.effective_start_date
462: <= l_session_date) --l_year_end

Line 489: from per_assignments_f paf,

485: faic.context prov_cd,
486: paa.assignment_action_id,
487: paa.payroll_action_id,
488: paf.effective_end_date
489: from per_assignments_f paf,
490: pay_assignment_actions paa,
491: ff_archive_items fai,
492: ff_archive_item_contexts faic,
493: ff_contexts fc,

Line 499: from per_assignments_f paf2

495: where paf.person_id >= stperson
496: and paf.person_id <= endperson
497: and paf.primary_flag = 'Y'
498: and paf.effective_start_date = (select max(paf2.effective_start_date)
499: from per_assignments_f paf2
500: where paf2.assignment_id= paf.assignment_id
501: and paf2.primary_flag = 'Y'
502: and paf2.effective_start_date
503: <= l_session_date) --l_year_end

Line 529: from per_assignments_f paf,

525: faic.context prov_cd,
526: paa.assignment_action_id,
527: paa.payroll_action_id,
528: paf.effective_end_date
529: from per_assignments_f paf,
530: pay_assignment_actions paa,
531: ff_archive_items fai,
532: ff_archive_item_contexts faic,
533: ff_contexts fc,

Line 540: from per_assignments_f paf2

536: where --paf.person_id >= stperson
537: --and paf.person_id <= endperson
538: paf.primary_flag = 'Y'
539: and paf.effective_start_date = (select max(paf2.effective_start_date)
540: from per_assignments_f paf2
541: where paf2.assignment_id= paf.assignment_id
542: and paf2.primary_flag = 'Y'
543: and paf2.effective_start_date
544: <= l_session_date) --l_year_end