APPS.PAY_US_REPORTING_UTILS_PKG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 2331: FROM ff_archive_item_contexts con2,

2327: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
2328: c_tax_unit_id hr_organization_units.organization_id%type)
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)

Line 2350: FROM ff_archive_item_contexts con2,

2346: c_tax_unit_id hr_organization_units.organization_id%type,
2347: c_jurisdiction_code varchar2)
2348: IS
2349: SELECT target.value
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

Line 2351: ff_archive_item_contexts con3,

2347: c_jurisdiction_code varchar2)
2348: IS
2349: SELECT target.value
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

Line 3060: FROM ff_archive_item_contexts faic,

3056: CURSOR cur_employee_count(p_payroll_action_id number,
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

Line 3102: FROM ff_archive_item_contexts faic,

3098: SELECT t1.user_name,sum(to_number(nvl(t1.value,'0')))
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,

Line 3109: ff_archive_item_contexts faic1,

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
3112: WHERE
3113: ppa.payroll_action_id = p_payroll_action_id

Line 3153: ff_archive_item_contexts faic2,

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
3157: and fai2.archive_item_id = fai1.archive_item_id

Line 3170: FROM ff_archive_item_contexts faic,

3166: p_tax_unit_id number,
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,

Line 3177: ff_archive_item_contexts faic1,

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
3180: WHERE
3181: ppa.payroll_action_id = p_payroll_action_id

Line 3222: ff_archive_item_contexts faic2,

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
3226: and fai2.archive_item_id = fai1.archive_item_id

Line 3240: FROM ff_archive_item_contexts faic,

3236: p_tax_unit_id number,
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,

Line 3247: --ff_archive_item_contexts faic1,

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
3250: WHERE
3251: ppa.payroll_action_id = p_payroll_action_id

Line 3286: ff_archive_item_contexts faic2,

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
3290: and fai2.archive_item_id = fai1.archive_item_id