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 PAY_ASSIGNMENT_ACTIONS

Line 67: pay_assignment_actions paa

63: ff_archive_items fai2,
64: ff_archive_items fai3,
65: ff_archive_items fai4,
66: pay_payroll_actions ppa,
67: pay_assignment_actions paa
68: where ppa.payroll_action_id = :payroll_action_id
69: and fai1.user_entity_id = ' || l_uid_caeoy_tax_year ||
70: ' and fai1.value =
71: nvl(pay_ca_t4_reg.get_parameter(''TAX_YEAR'',

Line 187: pay_assignment_actions paa,

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
191: where paf.person_id between stperson

Line 221: pay_assignment_actions paa,

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,
225: pay_population_ranges ppr

Line 258: pay_assignment_actions paa,

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,
262: per_periods_of_service PDS

Line 293: pay_assignment_actions paa,

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,
297: pay_population_ranges ppr,

Line 335: pay_assignment_actions paa,

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
339: where paf.person_id between stperson

Line 371: pay_assignment_actions paa,

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,
375: per_periods_of_service PDS

Line 411: pay_assignment_actions paa,

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
415: where paf.person_id >= stperson

Line 449: pay_assignment_actions paa,

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,
453: pay_population_ranges ppr

Line 490: pay_assignment_actions paa,

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,
494: per_periods_of_service PDS

Line 530: pay_assignment_actions paa,

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,
534: pay_population_ranges ppr,

Line 863: select pay_assignment_actions_s.nextval

859: 'ASSIGNMENT',
860: l_asg_id,
861: l_effective_end_date),'Y') = 'Y') or l_report_type <> 'T4_XML' then
862:
863: select pay_assignment_actions_s.nextval
864: into lockingactid
865: from dual;
866:
867: hr_nonrun_asact.insact(lockingactid,

Line 882: update pay_assignment_actions paa

878: lpad(to_char(ln_arch_pact_id),14,0);
879:
880: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
881:
882: update pay_assignment_actions paa
883: set paa.serial_number = lv_serial_number
884: where paa.assignment_action_id = lockingactid;
885: end if;
886:

Line 1155: select pay_assignment_actions_s.nextval

1151: 'PRINT',
1152: 'ASSIGNMENT',
1153: l_asg_id,
1154: l_effective_end_date),'Y') = 'Y') or l_report_type <> 'T4_XML' then
1155: select pay_assignment_actions_s.nextval
1156: into lockingactid
1157: from dual;
1158:
1159: hr_nonrun_asact.insact(lockingactid,

Line 1176: update pay_assignment_actions paa

1172: lpad(to_char(ln_arch_pact_id),14,0);
1173:
1174: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
1175:
1176: update pay_assignment_actions paa
1177: set paa.serial_number = lv_serial_number
1178: where paa.assignment_action_id = lockingactid;
1179:
1180: end if;

Line 1282: pay_assignment_actions paa1,

1278: hr_all_organization_units hou1,
1279: hr_locations_all loc,
1280: per_all_people_f ppf,
1281: per_all_assignments_f paf,
1282: pay_assignment_actions paa1,
1283: pay_payroll_actions ppa1
1284: where ppa1.payroll_action_id = :pactid
1285: and paa1.payroll_action_id = ppa1.payroll_action_id
1286: and paa1.assignment_id = paf.assignment_id