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 FF_ARCHIVE_ITEMS

Line 62: from ff_archive_items fai1,

58:
59: /* pay reg code */
60:
61: sqlstr := 'select distinct to_number(fai4.value)
62: from ff_archive_items fai1,
63: ff_archive_items fai2,
64: ff_archive_items fai3,
65: ff_archive_items fai4,
66: pay_payroll_actions ppa,

Line 63: ff_archive_items fai2,

59: /* pay reg code */
60:
61: sqlstr := 'select distinct to_number(fai4.value)
62: from ff_archive_items fai1,
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

Line 64: ff_archive_items fai3,

60:
61: sqlstr := 'select distinct to_number(fai4.value)
62: from ff_archive_items fai1,
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

Line 65: ff_archive_items fai4,

61: sqlstr := 'select distinct to_number(fai4.value)
62: from ff_archive_items fai1,
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 ||

Line 180: ff_archive_items fai,

176: paa.assignment_action_id,
177: paa.payroll_action_id
178: from per_assignments_f paf,
179: pay_assignment_actions paa,
180: ff_archive_items fai,
181: ff_contexts fc,
182: ff_archive_item_contexts faic
183: where paf.person_id between stperson
184: and endperson

Line 212: ff_archive_items fai,

208: paa.assignment_action_id,
209: paa.payroll_action_id
210: from per_assignments_f paf,
211: pay_assignment_actions paa,
212: ff_archive_items fai,
213: ff_contexts fc,
214: ff_archive_item_contexts faic
215: where paf.person_id between stperson
216: and endperson

Line 246: ff_archive_items fai,

242: paa.assignment_action_id,
243: paa.payroll_action_id
244: from per_assignments_f paf,
245: pay_assignment_actions paa,
246: ff_archive_items fai,
247: ff_archive_item_contexts faic,
248: ff_contexts fc
249: where paf.person_id >= stperson
250: and paf.person_id <= endperson