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 dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 359: FROM ff_archive_item_contexts con3,

355: /* cursor to check if the state tax Rules have been added or Not. */
356: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)
357: IS
358: SELECT 'Y'
359: FROM ff_archive_item_contexts con3,
360: ff_archive_item_contexts con2,
361: ff_contexts fc3,
362: ff_contexts fc2,
363: ff_archive_items target,

Line 360: ff_archive_item_contexts con2,

356: CURSOR c_chk_archive_state_code(cp_tax_unit_id number,cp_payroll_action_id number)
357: IS
358: SELECT 'Y'
359: FROM ff_archive_item_contexts con3,
360: ff_archive_item_contexts con2,
361: ff_contexts fc3,
362: ff_contexts fc2,
363: ff_archive_items target,
364: ff_database_items fdi

Line 900: FROM ff_archive_item_contexts faic,

896: ELSIF p_report_type = 'STW2' THEN
897: p_sqlstr := '
898: SELECT DISTINCT
899: to_number(paa.serial_number)
900: FROM ff_archive_item_contexts faic,
901: ff_archive_items fai,
902: ff_database_items fdi,
903: pay_assignment_actions paa,
904: pay_payroll_actions ppa,

Line 997: ff_archive_item_contexts faic1, -- city_context

993: per_all_assignments_f paf,
994: pay_payroll_actions ppa1,
995: ff_contexts fc1 , --for city context
996: ff_archive_items fai1, -- city
997: ff_archive_item_contexts faic1, -- city_context
998: ff_database_items fdi1 --database_items for City_withheld
999: --,pay_us_city_tax_info_f puctif
1000: WHERE
1001: ppa1.payroll_action_id = p_pactid

Line 1078: from ff_archive_item_contexts faic,

1074: FOR UPDATE OF paf.assignment_id;
1075: cursor csr_get_fed_wages(p_assignment_action_id number,
1076: p_tax_unit_id number) is
1077: select to_number(fai.value)
1078: from ff_archive_item_contexts faic,
1079: ff_archive_items fai,
1080: ff_contexts fc,
1081: ff_database_items fdi
1082: where fdi.user_name = 'A_GROSS_EARNINGS_PER_GRE_YTD'

Line 1298: ff_archive_item_contexts faic

1294: SELECT value
1295: INTO l_ein_val
1296: FROM ff_archive_items fai,
1297: ff_contexts fc,
1298: ff_archive_item_contexts faic
1299: WHERE fai.context1 = to_char(p_pactid)
1300: AND user_entity_id = c_id.user_entity_id
1301: AND faic.archive_item_id = fai.archive_item_id
1302: AND faic.context = to_char(l_gre)

Line 1347: ff_archive_item_contexts faic,

1343: CURSOR c_get_state_id
1344: IS
1345: SELECT value
1346: FROM ff_archive_items fai,
1347: ff_archive_item_contexts faic,
1348: ff_archive_item_contexts faic1
1349: WHERE context1 = to_char(p_pactid)
1350: AND user_entity_id = l_sit_state_id
1351: AND faic.archive_item_id = fai.archive_item_id

Line 1348: ff_archive_item_contexts faic1

1344: IS
1345: SELECT value
1346: FROM ff_archive_items fai,
1347: ff_archive_item_contexts faic,
1348: ff_archive_item_contexts faic1
1349: WHERE context1 = to_char(p_pactid)
1350: AND user_entity_id = l_sit_state_id
1351: AND faic.archive_item_id = fai.archive_item_id
1352: AND faic1.archive_item_id = fai.archive_item_id

Line 1446: ff_archive_item_contexts con3,

1442: cp_state_Code varchar2 )
1443: IS
1444: SELECT target.value
1445: FROM
1446: ff_archive_item_contexts con3,
1447: ff_archive_item_contexts con2,
1448: ff_contexts fc3,
1449: ff_contexts fc2,
1450: ff_archive_items target,

Line 1447: ff_archive_item_contexts con2,

1443: IS
1444: SELECT target.value
1445: FROM
1446: ff_archive_item_contexts con3,
1447: ff_archive_item_contexts con2,
1448: ff_contexts fc3,
1449: ff_contexts fc2,
1450: ff_archive_items target,
1451: ff_database_items fdi