DBA Data[Home] [Help]

APPS.PAY_IP_PAYROLL_ARCH dependencies on HR_ORGANIZATION_UNITS

Line 3097: hr_organization_units hou

3093: region_1, region_2,
3094: region_3, postal_code,
3095: country, telephone_number_1
3096: FROM hr_locations hl,
3097: hr_organization_units hou
3098: WHERE hou.organization_id = cp_organization_id
3099: AND hou.location_id = hl.location_id;
3100:
3101: lv_er_name hr_organization_units.name%TYPE;

Line 3101: lv_er_name hr_organization_units.name%TYPE;

3097: hr_organization_units hou
3098: WHERE hou.organization_id = cp_organization_id
3099: AND hou.location_id = hl.location_id;
3100:
3101: lv_er_name hr_organization_units.name%TYPE;
3102: lv_er_address_line_1 hr_locations.address_line_1%TYPE;
3103: lv_er_address_line_2 hr_locations.address_line_2%TYPE;
3104: lv_er_address_line_3 hr_locations.address_line_3%TYPE;
3105: lv_er_town_or_city hr_locations.town_or_city%TYPE;