DBA Data[Home] [Help]

APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on HR_LOCATIONS_ALL

Line 1606: FROM hr_locations_all hr_loc, xle_firstparty_information_v xle_firstparty

1602: AND status = 'A';
1603:
1604: CURSOR l_hr_loc_contact_csr (p_party_id IN NUMBER) IS
1605: SELECT TELEPHONE_NUMBER_1, TELEPHONE_NUMBER_2
1606: FROM hr_locations_all hr_loc, xle_firstparty_information_v xle_firstparty
1607: WHERE hr_loc.location_id = xle_firstparty.location_id
1608: AND xle_firstparty.party_id = p_party_id;
1609:
1610: BEGIN

Line 1841: FROM hr_locations_all

1837: CURSOR l_hr_loc_csr (p_hr_location_id IN NUMBER) IS
1838: SELECT address_line_1, address_line_2, address_line_3,
1839: town_or_city, region_1, region_2,
1840: postal_code, country
1841: FROM hr_locations_all
1842: WHERE location_id = p_hr_location_id;
1843:
1844: BEGIN
1845: