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_ITEMS

Line 2282: l_archived_value ff_archive_items.value%type;

2278: return varchar2 IS
2279:
2280: l_err boolean;
2281: l_entity_id ff_database_items.user_entity_id%type;
2282: l_archived_value ff_archive_items.value%type;
2283: l_jurisdiction_code varchar2(25);
2284: l_message varchar2(1000);
2285: l_state_wage varchar2(100);
2286: l_main_return varchar2(100);

Line 2290: p_archived_value ff_archive_items.value%type);

2286: l_main_return varchar2(100);
2287:
2288: TYPE dbi_columns IS RECORD(
2289: p_user_name ff_database_items.user_name%type,
2290: p_archived_value ff_archive_items.value%type);
2291:
2292: dbi_rec dbi_columns;
2293:
2294: TYPE dbi_infm IS TABLE OF dbi_rec%TYPE

Line 2316: ff_archive_items target

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)
2319: /* context assignment action id */
2320: AND fc2.context_name = 'TAX_UNIT_ID'

Line 2337: ff_archive_items target

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
2339: AND target.context1 = to_char(c_assignment_action_id)
2340: /* context assignment action id */
2341: AND fc2.context_name = 'TAX_UNIT_ID'

Line 3007: from ff_archive_items fai,

3003: FOR i in get_all_assignment (p_payroll_action_id, p_tax_unit_id) LOOP
3004:
3005: Select fai.value
3006: into lv_employee_count
3007: from ff_archive_items fai,
3008: ff_database_items fdi
3009: where fdi.user_name = p_database_item_name /*eg A_SQWL_MONTH1_COUNT */
3010: and fai.user_entity_id = fdi.user_entity_id
3011: and fai.context1 = i.assignment_action_id ;

Line 3042: ff_archive_items fai,

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
3046: WHERE

Line 3076: ff_archive_items fai,

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,
3080: ff_archive_items fai1,

Line 3080: ff_archive_items fai1,

3076: ff_archive_items fai,
3077: ff_database_items fdi,
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

Line 3125: from ff_archive_items fai2,

3121: and pus.state_abbrev = p_state
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

Line 3163: ff_archive_items fai,

3159: select sum(to_number(nvl(fai.value, '0')) - to_number(nvl(fai1.value, '0')))
3160: into lv_total_wages
3161: from pay_payroll_actions ppa,
3162: pay_assignment_actions paa,
3163: ff_archive_items fai,
3164: ff_archive_items fai1,
3165: ff_database_items fdi,
3166: ff_database_items fdi1
3167: where ppa.payroll_action_id = p_payroll_action_id

Line 3164: ff_archive_items fai1,

3160: into lv_total_wages
3161: from pay_payroll_actions ppa,
3162: pay_assignment_actions paa,
3163: ff_archive_items fai,
3164: ff_archive_items fai1,
3165: ff_database_items fdi,
3166: ff_database_items fdi1
3167: where ppa.payroll_action_id = p_payroll_action_id
3168: and ppa.payroll_action_id = paa.payroll_action_id

Line 3272: ff_archive_items fai,

3268: ),0)
3269: into p_excess_wages
3270: from pay_payroll_actions ppa,
3271: pay_assignment_actions paa,
3272: ff_archive_items fai,
3273: ff_archive_items fai1,
3274: ff_archive_items fai2,
3275: ff_database_items fdi,
3276: ff_database_items fdi1,

Line 3273: ff_archive_items fai1,

3269: into p_excess_wages
3270: from pay_payroll_actions ppa,
3271: pay_assignment_actions paa,
3272: ff_archive_items fai,
3273: ff_archive_items fai1,
3274: ff_archive_items fai2,
3275: ff_database_items fdi,
3276: ff_database_items fdi1,
3277: ff_database_items fdi2

Line 3274: ff_archive_items fai2,

3270: from pay_payroll_actions ppa,
3271: pay_assignment_actions paa,
3272: ff_archive_items fai,
3273: ff_archive_items fai1,
3274: ff_archive_items fai2,
3275: ff_database_items fdi,
3276: ff_database_items fdi1,
3277: ff_database_items fdi2
3278: where ppa.payroll_action_id = p_payroll_action_id

Line 3295: ff_archive_items fai,

3291: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3292: into p_withholding
3293: from pay_payroll_actions ppa,
3294: pay_assignment_actions paa,
3295: ff_archive_items fai,
3296: ff_database_items fdi
3297: where ppa.payroll_action_id = p_payroll_action_id
3298: and ppa.payroll_action_id = paa.payroll_action_id
3299: and paa.tax_unit_id = p_tax_unit_id

Line 3311: ff_archive_items fai,

3307: ),0)
3308: into p_workerscomp
3309: from pay_payroll_actions ppa,
3310: pay_assignment_actions paa,
3311: ff_archive_items fai,
3312: ff_archive_items fai1,
3313: ff_archive_items fai2,
3314: ff_database_items fdi,
3315: ff_database_items fdi1,

Line 3312: ff_archive_items fai1,

3308: into p_workerscomp
3309: from pay_payroll_actions ppa,
3310: pay_assignment_actions paa,
3311: ff_archive_items fai,
3312: ff_archive_items fai1,
3313: ff_archive_items fai2,
3314: ff_database_items fdi,
3315: ff_database_items fdi1,
3316: ff_database_items fdi2

Line 3313: ff_archive_items fai2,

3309: from pay_payroll_actions ppa,
3310: pay_assignment_actions paa,
3311: ff_archive_items fai,
3312: ff_archive_items fai1,
3313: ff_archive_items fai2,
3314: ff_database_items fdi,
3315: ff_database_items fdi1,
3316: ff_database_items fdi2
3317: where ppa.payroll_action_id = p_payroll_action_id

Line 3352: ff_archive_items fai,

3348: p_sui_taxable,
3349: p_sui_gross
3350: from pay_payroll_actions ppa,
3351: pay_assignment_actions paa,
3352: ff_archive_items fai,
3353: ff_archive_items fai1,
3354: ff_archive_items fai2,
3355: ff_archive_items fai3,
3356: ff_database_items fdi,

Line 3353: ff_archive_items fai1,

3349: p_sui_gross
3350: from pay_payroll_actions ppa,
3351: pay_assignment_actions paa,
3352: ff_archive_items fai,
3353: ff_archive_items fai1,
3354: ff_archive_items fai2,
3355: ff_archive_items fai3,
3356: ff_database_items fdi,
3357: ff_database_items fdi1,

Line 3354: ff_archive_items fai2,

3350: from pay_payroll_actions ppa,
3351: pay_assignment_actions paa,
3352: ff_archive_items fai,
3353: ff_archive_items fai1,
3354: ff_archive_items fai2,
3355: ff_archive_items fai3,
3356: ff_database_items fdi,
3357: ff_database_items fdi1,
3358: ff_database_items fdi2,

Line 3355: ff_archive_items fai3,

3351: pay_assignment_actions paa,
3352: ff_archive_items fai,
3353: ff_archive_items fai1,
3354: ff_archive_items fai2,
3355: ff_archive_items fai3,
3356: ff_database_items fdi,
3357: ff_database_items fdi1,
3358: ff_database_items fdi2,
3359: ff_database_items fdi3