APPS.IBY_FD_EXTRACT_GEN_PVT dependencies on XLE_FIRSTPARTY_INFORMATION_V
Line 2121: FROM hr_locations_all hr_loc, xle_firstparty_information_v xle_firstparty
2117: AND status = 'A';
2118:
2119: CURSOR l_hr_loc_contact_csr (p_party_id IN NUMBER) IS
2120: SELECT TELEPHONE_NUMBER_1, TELEPHONE_NUMBER_2 2121: FROM hr_locations_all hr_loc, xle_firstparty_information_v xle_firstparty 2122: WHERE hr_loc.location_id = xle_firstparty.location_id
2123: AND xle_firstparty.party_id = p_party_id;
2124:
2125: BEGIN