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 2299: l_archived_value ff_archive_items.value%type;

2295: return varchar2 IS
2296:
2297: l_err boolean;
2298: l_entity_id ff_database_items.user_entity_id%type;
2299: l_archived_value ff_archive_items.value%type;
2300: l_jurisdiction_code varchar2(25);
2301: l_message varchar2(1000);
2302: l_state_wage varchar2(100);
2303: l_main_return varchar2(100);

Line 2307: p_archived_value ff_archive_items.value%type);

2303: l_main_return varchar2(100);
2304:
2305: TYPE dbi_columns IS RECORD(
2306: p_user_name ff_database_items.user_name%type,
2307: p_archived_value ff_archive_items.value%type);
2308:
2309: dbi_rec dbi_columns;
2310:
2311: TYPE dbi_infm IS TABLE OF dbi_rec%TYPE

Line 2333: ff_archive_items target

2329: IS
2330: SELECT target.value
2331: FROM ff_archive_item_contexts con2,
2332: ff_contexts fc2,
2333: ff_archive_items target
2334: WHERE target.user_entity_id = c_user_entity_id
2335: AND target.context1 = to_char(c_assignment_action_id)
2336: /* context assignment action id */
2337: AND fc2.context_name = 'TAX_UNIT_ID'

Line 2354: ff_archive_items target

2350: FROM ff_archive_item_contexts con2,
2351: ff_archive_item_contexts con3,
2352: ff_contexts fc2,
2353: ff_contexts fc3,
2354: ff_archive_items target
2355: WHERE target.user_entity_id = c_user_entity_id
2356: AND target.context1 = to_char(c_assignment_action_id)
2357: /* context assignment action id */
2358: AND fc2.context_name = 'TAX_UNIT_ID'

Line 3026: from ff_archive_items fai,

3022: FOR i in get_all_assignment (p_payroll_action_id, p_tax_unit_id) LOOP
3023:
3024: Select fai.value
3025: into lv_employee_count
3026: from ff_archive_items fai,
3027: ff_database_items fdi
3028: where fdi.user_name = p_database_item_name /*eg A_SQWL_MONTH1_COUNT */
3029: and fai.user_entity_id = fdi.user_entity_id
3030: and fai.context1 = i.assignment_action_id ;

Line 3061: ff_archive_items fai,

3057: p_tax_unit_id number,
3058: p_state varchar2) IS
3059: SELECT count(*)
3060: FROM ff_archive_item_contexts faic,
3061: ff_archive_items fai,
3062: ff_database_items fdi,
3063: pay_assignment_actions paa,
3064: pay_payroll_actions ppa
3065: WHERE

Line 3103: ff_archive_items fai,

3099: FROM (
3100: SELECT distinct fdi1.user_name,fai1.value
3101: --sum(to_number(nvl( fai1.value,'0')))
3102: FROM ff_archive_item_contexts faic,
3103: ff_archive_items fai,
3104: ff_database_items fdi,
3105: pay_assignment_actions paa,
3106: pay_payroll_actions ppa,
3107: ff_archive_items fai1,

Line 3107: ff_archive_items fai1,

3103: ff_archive_items fai,
3104: ff_database_items fdi,
3105: pay_assignment_actions paa,
3106: pay_payroll_actions ppa,
3107: ff_archive_items fai1,
3108: ff_database_items fdi1,
3109: ff_archive_item_contexts faic1,
3110: ff_contexts fc,
3111: pay_us_states pus

Line 3152: from ff_archive_items fai2,

3148: and pus.state_abbrev = p_state
3149: )
3150: or
3151: not exists (select 'x'
3152: from ff_archive_items fai2,
3153: ff_archive_item_contexts faic2,
3154: ff_contexts fc2
3155: where fai2.user_entity_id = fdi1.user_entity_id
3156: and fai2.context1 = fai1.context1

Line 3171: ff_archive_items fai,

3167: p_state varchar2) IS
3168: SELECT fdi1.user_name,
3169: sum(to_number(nvl(fai1.value,'0')))
3170: FROM ff_archive_item_contexts faic,
3171: ff_archive_items fai,
3172: ff_database_items fdi,
3173: pay_assignment_actions paa,
3174: pay_payroll_actions ppa,
3175: ff_archive_items fai1,

Line 3175: ff_archive_items fai1,

3171: ff_archive_items fai,
3172: ff_database_items fdi,
3173: pay_assignment_actions paa,
3174: pay_payroll_actions ppa,
3175: ff_archive_items fai1,
3176: ff_database_items fdi1,
3177: ff_archive_item_contexts faic1,
3178: ff_contexts fc,
3179: pay_us_states pus

Line 3221: from ff_archive_items fai2,

3217: and pus.state_abbrev = p_state
3218: )--Commented the below clause as it is not required for SIT balances
3219: /* or
3220: not exists (select 'x'
3221: from ff_archive_items fai2,
3222: ff_archive_item_contexts faic2,
3223: ff_contexts fc2
3224: where fai2.user_entity_id = fdi1.user_entity_id
3225: and fai2.context1 = fai1.context1

Line 3241: ff_archive_items fai,

3237: p_state varchar2) IS
3238: SELECT fdi1.user_name,
3239: sum(to_number(nvl(fai1.value,'0')))
3240: FROM ff_archive_item_contexts faic,
3241: ff_archive_items fai,
3242: ff_database_items fdi,
3243: pay_assignment_actions paa,
3244: pay_payroll_actions ppa,
3245: ff_archive_items fai1,

Line 3245: ff_archive_items fai1,

3241: ff_archive_items fai,
3242: ff_database_items fdi,
3243: pay_assignment_actions paa,
3244: pay_payroll_actions ppa,
3245: ff_archive_items fai1,
3246: ff_database_items fdi1
3247: --ff_archive_item_contexts faic1,
3248: --ff_contexts fc,
3249: --pay_us_states pus

Line 3285: from ff_archive_items fai2,

3281: and pus.state_abbrev = p_state
3282: )
3283: or
3284: not exists (select 'x'
3285: from ff_archive_items fai2,
3286: ff_archive_item_contexts faic2,
3287: ff_contexts fc2
3288: where fai2.user_entity_id = fdi1.user_entity_id
3289: and fai2.context1 = fai1.context1

Line 3323: ff_archive_items fai,

3319: select sum(to_number(nvl(fai.value, '0')) - to_number(nvl(fai1.value, '0')))
3320: into lv_total_wages
3321: from pay_payroll_actions ppa,
3322: pay_assignment_actions paa,
3323: ff_archive_items fai,
3324: ff_archive_items fai1,
3325: ff_database_items fdi,
3326: ff_database_items fdi1
3327: where ppa.payroll_action_id = p_payroll_action_id

Line 3324: ff_archive_items fai1,

3320: into lv_total_wages
3321: from pay_payroll_actions ppa,
3322: pay_assignment_actions paa,
3323: ff_archive_items fai,
3324: ff_archive_items fai1,
3325: ff_database_items fdi,
3326: ff_database_items fdi1
3327: where ppa.payroll_action_id = p_payroll_action_id
3328: and ppa.payroll_action_id = paa.payroll_action_id

Line 3453: ff_archive_items fai,

3449: ),0)
3450: into p_excess_wages
3451: from pay_payroll_actions ppa,
3452: pay_assignment_actions paa,
3453: ff_archive_items fai,
3454: ff_archive_items fai1,
3455: ff_archive_items fai2,
3456: ff_database_items fdi,
3457: ff_database_items fdi1,

Line 3454: ff_archive_items fai1,

3450: into p_excess_wages
3451: from pay_payroll_actions ppa,
3452: pay_assignment_actions paa,
3453: ff_archive_items fai,
3454: ff_archive_items fai1,
3455: ff_archive_items fai2,
3456: ff_database_items fdi,
3457: ff_database_items fdi1,
3458: ff_database_items fdi2

Line 3455: ff_archive_items fai2,

3451: from pay_payroll_actions ppa,
3452: pay_assignment_actions paa,
3453: ff_archive_items fai,
3454: ff_archive_items fai1,
3455: ff_archive_items fai2,
3456: ff_database_items fdi,
3457: ff_database_items fdi1,
3458: ff_database_items fdi2
3459: where ppa.payroll_action_id = p_payroll_action_id

Line 3476: ff_archive_items fai,

3472: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3473: into p_withholding
3474: from pay_payroll_actions ppa,
3475: pay_assignment_actions paa,
3476: ff_archive_items fai,
3477: ff_database_items fdi
3478: where ppa.payroll_action_id = p_payroll_action_id
3479: and ppa.payroll_action_id = paa.payroll_action_id
3480: and paa.tax_unit_id = p_tax_unit_id

Line 3492: ff_archive_items fai,

3488: ),0)
3489: into p_workerscomp
3490: from pay_payroll_actions ppa,
3491: pay_assignment_actions paa,
3492: ff_archive_items fai,
3493: ff_archive_items fai1,
3494: ff_archive_items fai2,
3495: ff_database_items fdi,
3496: ff_database_items fdi1,

Line 3493: ff_archive_items fai1,

3489: into p_workerscomp
3490: from pay_payroll_actions ppa,
3491: pay_assignment_actions paa,
3492: ff_archive_items fai,
3493: ff_archive_items fai1,
3494: ff_archive_items fai2,
3495: ff_database_items fdi,
3496: ff_database_items fdi1,
3497: ff_database_items fdi2

Line 3494: ff_archive_items fai2,

3490: from pay_payroll_actions ppa,
3491: pay_assignment_actions paa,
3492: ff_archive_items fai,
3493: ff_archive_items fai1,
3494: ff_archive_items fai2,
3495: ff_database_items fdi,
3496: ff_database_items fdi1,
3497: ff_database_items fdi2
3498: where ppa.payroll_action_id = p_payroll_action_id

Line 3554: ff_archive_items fai,

3550: p_sui_taxable,
3551: p_sui_gross
3552: from pay_payroll_actions ppa,
3553: pay_assignment_actions paa,
3554: ff_archive_items fai,
3555: ff_archive_items fai1,
3556: ff_archive_items fai2,
3557: ff_archive_items fai3,
3558: ff_database_items fdi,

Line 3555: ff_archive_items fai1,

3551: p_sui_gross
3552: from pay_payroll_actions ppa,
3553: pay_assignment_actions paa,
3554: ff_archive_items fai,
3555: ff_archive_items fai1,
3556: ff_archive_items fai2,
3557: ff_archive_items fai3,
3558: ff_database_items fdi,
3559: ff_database_items fdi1,

Line 3556: ff_archive_items fai2,

3552: from pay_payroll_actions ppa,
3553: pay_assignment_actions paa,
3554: ff_archive_items fai,
3555: ff_archive_items fai1,
3556: ff_archive_items fai2,
3557: ff_archive_items fai3,
3558: ff_database_items fdi,
3559: ff_database_items fdi1,
3560: ff_database_items fdi2,

Line 3557: ff_archive_items fai3,

3553: pay_assignment_actions paa,
3554: ff_archive_items fai,
3555: ff_archive_items fai1,
3556: ff_archive_items fai2,
3557: ff_archive_items fai3,
3558: ff_database_items fdi,
3559: ff_database_items fdi1,
3560: ff_database_items fdi2,
3561: ff_database_items fdi3

Line 3592: ff_archive_items fai,

3588: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3589: into p_sui_taxable
3590: from pay_payroll_actions ppa,
3591: pay_assignment_actions paa,
3592: ff_archive_items fai,
3593: ff_database_items fdi
3594: where ppa.payroll_action_id = p_payroll_action_id
3595: and ppa.payroll_action_id = paa.payroll_action_id
3596: and paa.tax_unit_id = p_tax_unit_id

Line 3620: ff_archive_items fai,

3616: select nvl(sum(to_number(nvl(fai.value, '0'))),0)
3617: into p_sui_taxable
3618: from pay_payroll_actions ppa,
3619: pay_assignment_actions paa,
3620: ff_archive_items fai,
3621: ff_database_items fdi
3622: where ppa.payroll_action_id = p_payroll_action_id
3623: and ppa.payroll_action_id = paa.payroll_action_id
3624: and paa.tax_unit_id = p_tax_unit_id