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

Line 320: ff_archive_items target,

316: FROM ff_archive_item_contexts con3,
317: ff_archive_item_contexts con2,
318: ff_contexts fc3,
319: ff_contexts fc2,
320: ff_archive_items target,
321: ff_database_items fdi
322: WHERE target.context1 = to_char(cp_payroll_action_id)
323: /* context of payroll_action_id */
324: AND fdi.user_name = 'A_FIPS_CODE_JD'

Line 853: ff_archive_items fai,

849: p_sqlstr := '
850: SELECT DISTINCT
851: to_number(paa.serial_number)
852: FROM ff_archive_item_contexts faic,
853: ff_archive_items fai,
854: ff_database_items fdi,
855: pay_assignment_actions paa,
856: pay_payroll_actions ppa,
857: per_all_assignments_f paf,

Line 941: ff_archive_items fai,

937: 'A_W2_STATE_WAGES',
938: paa.tax_unit_id,
939: faic.context , 2),0)
940: FROM ff_archive_item_contexts faic,
941: ff_archive_items fai,
942: ff_database_items fdi,
943: pay_assignment_actions paa,
944: pay_payroll_actions ppa,
945: per_all_assignments_f paf,

Line 1005: ff_archive_items fai,

1001: 'A_W2_STATE_WAGES',
1002: paa.tax_unit_id,
1003: faic.context , 2),0)
1004: FROM ff_archive_item_contexts faic,
1005: ff_archive_items fai,
1006: ff_database_items fdi,
1007: pay_assignment_actions paa,
1008: pay_payroll_actions ppa,
1009: per_all_assignments_f paf,

Line 1084: ff_archive_items fai,

1080: p_assignment_action_id number,
1081: p_tax_unit_id number) is
1082: select to_number(fai.value) value
1083: from ff_archive_item_contexts faic,
1084: ff_archive_items fai,
1085: ff_contexts fc,
1086: ff_database_items fdi
1087: where fdi.user_name = p_user_name
1088: and fc.context_name = 'TAX_UNIT_ID'

Line 1100: ff_archive_items fai,

1096: cursor csr_get_fit_sub_wages(p_assignment_action_id number,
1097: p_tax_unit_id number) is
1098: select to_number(fai.value) value
1099: from ff_archive_item_contexts faic,
1100: ff_archive_items fai,
1101: ff_contexts fc,
1102: ff_database_items fdi
1103: where fdi.user_name IN ('A_REGULAR_EARNINGS_PER_GRE_YTD',
1104: 'A_SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_PER_GRE_YTD',

Line 1390: FROM ff_archive_items fai,

1386: FOR c_id IN c_get_user_entity_id LOOP
1387:
1388: SELECT value
1389: INTO l_ein_val
1390: FROM ff_archive_items fai,
1391: ff_contexts fc,
1392: ff_archive_item_contexts faic
1393: WHERE fai.context1 = to_char(p_pactid)
1394: AND user_entity_id = c_id.user_entity_id

Line 1440: FROM ff_archive_items fai,

1436:
1437: CURSOR c_get_state_id
1438: IS
1439: SELECT value
1440: FROM ff_archive_items fai,
1441: ff_archive_item_contexts faic,
1442: ff_archive_item_contexts faic1
1443: WHERE context1 = to_char(p_pactid)
1444: AND user_entity_id = l_sit_state_id

Line 1550: ff_archive_items target,

1546: ff_archive_item_contexts con3,
1547: ff_archive_item_contexts con2,
1548: ff_contexts fc3,
1549: ff_contexts fc2,
1550: ff_archive_items target,
1551: ff_database_items fdi
1552: WHERE target.context1 = to_char(cp_payroll_action_id)
1553: /* context of payroll_action_id */
1554: and fdi.user_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID'

Line 1704: ff_archive_items fai

1700: FROM DUAL
1701: WHERE EXISTS
1702: (SELECT NULL
1703: FROM pay_payroll_actions ppa,
1704: ff_archive_items fai
1705: WHERE ppa.report_type = 'YREND'
1706: AND ppa.report_qualifier = 'FED'
1707: AND ppa.report_category = 'RT'
1708: AND ppa.effective_date = p_effective_date