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.

[Home] [Help]

APPS.PAY_US_REPORTING_UTILS_PKG dependencies on FF_CONTEXTS

Line 2332: ff_contexts fc2,

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)
2336: /* context assignment action id */

Line 2352: ff_contexts fc2,

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
2356: AND target.context1 = to_char(c_assignment_action_id)

Line 2353: ff_contexts fc3,

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
2356: AND target.context1 = to_char(c_assignment_action_id)
2357: /* context assignment action id */

Line 3110: ff_contexts fc,

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

Line 3154: ff_contexts fc2

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
3158: and fai2.archive_item_id = faic2.archive_item_id

Line 3178: ff_contexts fc,

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

Line 3223: ff_contexts fc2

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
3227: and fai2.archive_item_id = faic2.archive_item_id

Line 3248: --ff_contexts fc,

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

Line 3287: ff_contexts fc2

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
3291: and fai2.archive_item_id = faic2.archive_item_id