APPS.PAY_US_REPORTING_UTILS_PKG dependencies on FF_CONTEXTS

Line 2315: ff_contexts fc2,

2311: c_tax_unit_id hr_organization_units.organization_id%type)
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 */

Line 2335: ff_contexts fc2,

2331: IS
2332: SELECT target.value
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)

Line 2336: ff_contexts fc3,

2332: SELECT target.value
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 */

Line 3083: ff_contexts fc,

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
3086: ppa.payroll_action_id = p_payroll_action_id
3087: and ppa.payroll_action_id = paa.payroll_action_id

Line 3127: ff_contexts fc2

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
3130: and fai2.archive_item_id = fai1.archive_item_id
3131: and fai2.archive_item_id = faic2.archive_item_id