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

Line 356: ff_archive_items fai,

352: cp_context_jursidiction number)
353: IS
354: SELECT 'Y'
355: FROM
356: ff_archive_items fai,
357: pay_assignment_actions paa,
358: pay_payroll_actions ppa
359: WHERE ppa.PAYROLL_ACTION_ID = CP_PAYROLL_ACTION_ID
360: AND ppa.payroll_action_id = paa.payroll_action_id

Line 390: ff_archive_items target,

386: ff_archive_item_contexts con3,
387: ff_archive_item_contexts con2,
388: ff_contexts fc3,
389: ff_contexts fc2,
390: ff_archive_items target,
391: ff_database_items fdi
392: WHERE target.context1 = cp_payroll_action_id
393: /* context of payroll_action_id */
394: and fdi.user_name = 'A_FIPS_CODE_JD'

Line 836: ff_archive_items fai,

832: p_sqlstr := '
833: SELECT DISTINCT
834: to_number(paa.serial_number)
835: FROM ff_archive_item_contexts faic,
836: ff_archive_items fai,
837: ff_database_items fdi,
838: pay_assignment_actions paa,
839: pay_payroll_actions ppa,
840: per_assignments_f paf,

Line 923: ff_archive_items fai,

919: 'A_W2_STATE_WAGES',
920: paa.tax_unit_id,
921: faic.context , 2),0)
922: FROM ff_archive_item_contexts faic,
923: ff_archive_items fai,
924: ff_database_items fdi,
925: pay_assignment_actions paa,
926: pay_payroll_actions ppa,
927: per_assignments_f paf,

Line 1005: ff_archive_items fai,

1001: cursor csr_get_fed_wages(p_assignment_action_id number,
1002: p_tax_unit_id number) is
1003: select to_number(fai.value)
1004: from ff_archive_item_contexts faic,
1005: ff_archive_items fai,
1006: ff_contexts fc,
1007: ff_database_items fdi
1008: where fdi.user_name = 'A_GROSS_EARNINGS_PER_GRE_YTD'
1009: and fc.context_name = 'TAX_UNIT_ID'