DBA Data[Home] [Help]

APPS.PAY_US_1099R_UDFS dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 405: FROM ff_archive_item_contexts con2,

401: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
402: c_tax_unit_id hr_organization_units.organization_id%type)
403: IS
404: SELECT target.value
405: FROM ff_archive_item_contexts con2,
406: ff_contexts fc2,
407: ff_archive_items target
408: WHERE target.user_entity_id = c_user_entity_id
409: AND target.context1 = to_char(c_assignment_action_id)

Line 554: ff_archive_item_contexts con3,

550: RETURN VARCHAR2 IS
551: CURSOR c_sum_of_city_withheld(c_assignment_action_id number,c_tax_unit_id number) IS
552: select nvl(sum(target.value),0)
553: from
554: ff_archive_item_contexts con3,
555: ff_archive_item_contexts con2,
556: ff_contexts fc3,
557: ff_contexts fc2,
558: ff_archive_items target,

Line 555: ff_archive_item_contexts con2,

551: CURSOR c_sum_of_city_withheld(c_assignment_action_id number,c_tax_unit_id number) IS
552: select nvl(sum(target.value),0)
553: from
554: ff_archive_item_contexts con3,
555: ff_archive_item_contexts con2,
556: ff_contexts fc3,
557: ff_contexts fc2,
558: ff_archive_items target,
559: ff_database_items fdi