DBA Data[Home] [Help]

APPS.PAY_US_1099R_UDFS dependencies on HR_ORGANIZATION_UNITS

Line 398: c_tax_unit_id hr_organization_units.organization_id%type)

394:
395: CURSOR get_archived_values(
396: c_user_entity_id ff_database_items.user_entity_id%type,
397: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
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,

Line 665: l_organization_name hr_organization_units.name%TYPE;

661: --
662:
663: c_item_name varchar2(40);
664: c_tax_unit_id hr_all_organization_units.organization_id%TYPE;
665: l_organization_name hr_organization_units.name%TYPE;
666: l_person_id number(10);
667: l_locality_company_id varchar2(50);
668: lr_employee_addr pay_us_get_item_data_pkg.person_name_address;
669: l_country varchar2(40);