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_DATABASE_ITEMS

Line 2281: l_entity_id ff_database_items.user_entity_id%type;

2277: sp_out_10 OUT nocopy varchar2)
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);

Line 2289: p_user_name ff_database_items.user_name%type,

2285: l_state_wage varchar2(100);
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:

Line 2300: (c_user_name ff_database_items.user_name%type) IS

2296:
2297: dbi_table dbi_infm;
2298:
2299: CURSOR get_user_entity_id
2300: (c_user_name ff_database_items.user_name%type) IS
2301: SELECT fdi.user_entity_id
2302: FROM ff_database_items fdi,
2303: ff_user_entities fue
2304: WHERE fue.legislation_code = 'US'

Line 2302: FROM ff_database_items fdi,

2298:
2299: CURSOR get_user_entity_id
2300: (c_user_name ff_database_items.user_name%type) IS
2301: SELECT fdi.user_entity_id
2302: FROM ff_database_items fdi,
2303: ff_user_entities fue
2304: WHERE fue.legislation_code = 'US'
2305: AND fue.user_entity_id = fdi.user_entity_id
2306: AND fdi.user_name = c_user_name;

Line 2309: c_user_entity_id ff_database_items.user_entity_id%type,

2305: AND fue.user_entity_id = fdi.user_entity_id
2306: AND fdi.user_name = c_user_name;
2307:
2308: CURSOR get_archived_values(
2309: c_user_entity_id ff_database_items.user_entity_id%type,
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

Line 2327: c_user_entity_id ff_database_items.user_entity_id%type,

2323: and ltrim(rtrim(con2.context)) = to_char(c_tax_unit_id);
2324: /*context of tax_unit_id */
2325:
2326: CURSOR get_jd_archived_values(
2327: c_user_entity_id ff_database_items.user_entity_id%type,
2328: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2329: c_tax_unit_id hr_organization_units.organization_id%type,
2330: c_jurisdiction_code varchar2)
2331: IS

Line 2779: ff_database_items DI

2775:
2776: CURSOR csr_defined_balance is
2777: SELECT to_number(UE.creator_id)
2778: FROM ff_user_entities UE,
2779: ff_database_items DI
2780: WHERE DI.user_name = p_db_item_name
2781: AND UE.user_entity_id = DI.user_entity_id
2782: AND Ue.creator_type = 'B'
2783: AND UE.legislation_code = 'US';

Line 3008: ff_database_items fdi

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 ;
3012:

Line 3043: ff_database_items fdi,

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
3047: ppa.payroll_action_id = p_payroll_action_id

Line 3077: ff_database_items fdi,

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,
3081: ff_database_items fdi1,

Line 3081: ff_database_items fdi1,

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

Line 3165: ff_database_items fdi,

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
3169: and paa.tax_unit_id = p_tax_unit_id

Line 3166: ff_database_items fdi1

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
3169: and paa.tax_unit_id = p_tax_unit_id
3170: and fai.context1 = paa.assignment_action_id

Line 3275: ff_database_items fdi,

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
3279: and ppa.payroll_action_id = paa.payroll_action_id

Line 3276: ff_database_items fdi1,

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
3279: and ppa.payroll_action_id = paa.payroll_action_id
3280: and paa.tax_unit_id = p_tax_unit_id

Line 3277: ff_database_items fdi2

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
3279: and ppa.payroll_action_id = paa.payroll_action_id
3280: and paa.tax_unit_id = p_tax_unit_id
3281: and fai.context1 = paa.assignment_action_id

Line 3296: ff_database_items fdi

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
3300: and fai.context1 = paa.assignment_action_id

Line 3314: ff_database_items fdi,

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
3318: and ppa.payroll_action_id = paa.payroll_action_id

Line 3315: ff_database_items fdi1,

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
3318: and ppa.payroll_action_id = paa.payroll_action_id
3319: and paa.tax_unit_id = p_tax_unit_id

Line 3316: ff_database_items fdi2

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
3318: and ppa.payroll_action_id = paa.payroll_action_id
3319: and paa.tax_unit_id = p_tax_unit_id
3320: and fai.context1 = paa.assignment_action_id

Line 3356: ff_database_items fdi,

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
3360: where ppa.payroll_action_id = p_payroll_action_id

Line 3357: ff_database_items fdi1,

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
3360: where ppa.payroll_action_id = p_payroll_action_id
3361: and ppa.payroll_action_id = paa.payroll_action_id

Line 3358: ff_database_items fdi2,

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
3360: where ppa.payroll_action_id = p_payroll_action_id
3361: and ppa.payroll_action_id = paa.payroll_action_id
3362: and paa.tax_unit_id = p_tax_unit_id

Line 3359: ff_database_items fdi3

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
3360: where ppa.payroll_action_id = p_payroll_action_id
3361: and ppa.payroll_action_id = paa.payroll_action_id
3362: and paa.tax_unit_id = p_tax_unit_id
3363: and fai.context1 = paa.assignment_action_id