398: c_tax_unit_id hr_organization_units.organization_id%type)
399: IS
400: SELECT target.value
401: FROM ff_archive_item_contexts con2,
402: ff_contexts fc2,
403: ff_archive_items target
404: WHERE target.user_entity_id = c_user_entity_id
405: AND target.context1 = to_char(c_assignment_action_id)
406: /* context assignment action id */
548: select nvl(sum(target.value),0)
549: from
550: ff_archive_item_contexts con3,
551: ff_archive_item_contexts con2,
552: ff_contexts fc3,
553: ff_contexts fc2,
554: ff_archive_items target,
555: ff_database_items fdi
556: where fdi.user_name = 'A_CITY_WITHHELD_PER_JD_GRE_YTD'
549: from
550: ff_archive_item_contexts con3,
551: ff_archive_item_contexts con2,
552: ff_contexts fc3,
553: ff_contexts fc2,
554: ff_archive_items target,
555: ff_database_items fdi
556: where fdi.user_name = 'A_CITY_WITHHELD_PER_JD_GRE_YTD'
557: and target.user_entity_id = fdi.user_entity_id