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_US_MMREF_LOCAL_XML dependencies on FF_ARCHIVE_ITEMS

Line 145: FROM ff_archive_items FAI,

141: CURSOR local_w2_xml_employee
142: IS
143: SELECT DISTINCT
144: 'TRANSFER_ACT_ID=P', AA.assignment_action_id
145: FROM ff_archive_items FAI,
146: ff_contexts FC, -- JD
147: ff_database_items FDI,
148: ff_archive_item_contexts FAIC,
149: per_all_people_f PE,

Line 196: FROM ff_archive_items FAI,

192: )
193: union
194: SELECT DISTINCT
195: 'TRANSFER_ACT_ID=P', AA.assignment_action_id
196: FROM ff_archive_items FAI,
197: ff_contexts FC, -- JD
198: ff_database_items FDI,
199: ff_archive_item_contexts FAIC,
200: per_all_people_f PE,

Line 254: FROM ff_archive_items FAI,

250: 'EE_ASSIGNMENT_ID=P', AA.assignment_id,
251: 'EE_DATE_EARNED=P', pay_magtape_generic.date_earned(PA.effective_date,
252: AA.assignment_id),
253: 'EE_LOCALITY_JD_CODE=P', substr(ltrim(rtrim(faic.context)),1,2)||'-000-'||substr(ltrim(rtrim(faic.context)),8,4)
254: FROM ff_archive_items FAI,
255: ff_contexts FC, -- JD
256: ff_database_items FDI,
257: ff_archive_item_contexts FAIC,
258: per_all_people_f PE,