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

Line 2314: FROM ff_archive_item_contexts con2,

2310: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2311: c_tax_unit_id hr_organization_units.organization_id%type)
2312: IS
2313: SELECT target.value
2314: FROM ff_archive_item_contexts con2,
2315: ff_contexts fc2,
2316: ff_archive_items target
2317: WHERE target.user_entity_id = c_user_entity_id
2318: AND target.context1 = to_char(c_assignment_action_id)

Line 2333: FROM ff_archive_item_contexts con2,

2329: c_tax_unit_id hr_organization_units.organization_id%type,
2330: c_jurisdiction_code varchar2)
2331: IS
2332: SELECT target.value
2333: FROM ff_archive_item_contexts con2,
2334: ff_archive_item_contexts con3,
2335: ff_contexts fc2,
2336: ff_contexts fc3,
2337: ff_archive_items target

Line 2334: ff_archive_item_contexts con3,

2330: c_jurisdiction_code varchar2)
2331: IS
2332: SELECT target.value
2333: FROM ff_archive_item_contexts con2,
2334: ff_archive_item_contexts con3,
2335: ff_contexts fc2,
2336: ff_contexts fc3,
2337: ff_archive_items target
2338: WHERE target.user_entity_id = c_user_entity_id

Line 3041: FROM ff_archive_item_contexts faic,

3037: CURSOR cur_employee_count(p_payroll_action_id number,
3038: p_tax_unit_id number,
3039: p_state varchar2) IS
3040: SELECT count(*)
3041: FROM ff_archive_item_contexts faic,
3042: ff_archive_items fai,
3043: ff_database_items fdi,
3044: pay_assignment_actions paa,
3045: pay_payroll_actions ppa

Line 3075: FROM ff_archive_item_contexts faic,

3071: p_tax_unit_id number,
3072: p_state varchar2) IS
3073: SELECT fdi1.user_name,
3074: sum(to_number(nvl(fai1.value,'0')))
3075: FROM ff_archive_item_contexts faic,
3076: ff_archive_items fai,
3077: ff_database_items fdi,
3078: pay_assignment_actions paa,
3079: pay_payroll_actions ppa,

Line 3082: ff_archive_item_contexts faic1,

3078: pay_assignment_actions paa,
3079: pay_payroll_actions ppa,
3080: ff_archive_items fai1,
3081: ff_database_items fdi1,
3082: ff_archive_item_contexts faic1,
3083: ff_contexts fc,
3084: pay_us_states pus
3085: WHERE
3086: ppa.payroll_action_id = p_payroll_action_id

Line 3126: ff_archive_item_contexts faic2,

3122: )
3123: or
3124: not exists (select 'x'
3125: from ff_archive_items fai2,
3126: ff_archive_item_contexts faic2,
3127: ff_contexts fc2
3128: where fai2.user_entity_id = fdi1.user_entity_id
3129: and fai2.context1 = fai1.context1
3130: and fai2.archive_item_id = fai1.archive_item_id