DBA Data[Home] [Help]

APPS.PAY_US_1099R_UDFS dependencies on HR_ORGANIZATION_UNITS

Line 402: c_tax_unit_id hr_organization_units.organization_id%type)

398:
399: CURSOR get_archived_values(
400: c_user_entity_id ff_database_items.user_entity_id%type,
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,

Line 670: l_organization_name hr_organization_units.name%TYPE;

666: --
667:
668: c_item_name varchar2(40);
669: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
670: l_organization_name hr_organization_units.name%TYPE;
671: l_person_id number(10);
672: l_locality_company_id varchar2(50);
673: lr_employee_addr pay_us_get_item_data_pkg.person_name_address;
674: l_country varchar2(40);