APPS.OKS_RENEW_CONTRACT_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1108: FROM hr_locations hrl, hr_all_organization_units hr, hz_parties hz

1104: l_gen_return_rec JTF_TERR_ASSIGN_PUB.bulk_winners_rec_type;
1105:
1106: CURSOR c_vendor_details(cp_org_id IN NUMBER, cp_party_id IN NUMBER) IS
1107: SELECT hz.party_name, hrl.country, hrl.region_2
1108: FROM hr_locations hrl, hr_all_organization_units hr, hz_parties hz
1109: WHERE hrl.location_id = hr.location_id
1110: AND hr.organization_id = cp_org_id
1111: AND hz.party_id = cp_party_id;
1112:

Line 1354: FROM hr_all_organization_units hr

1350:
1351: --gets the org name for the org id
1352: CURSOR c_get_org_name(cp_org_id IN NUMBER) IS
1353: SELECT hr.name
1354: FROM hr_all_organization_units hr
1355: WHERE hr.organization_id = cp_org_id;
1356:
1357:
1358: --gets the contract vendor/merhcant record id, rle_code from okc_k_party_roles_b

Line 1403: l_org_name hr_all_organization_units.name%TYPE;

1399: l_login_id NUMBER;
1400: l_id_tbl num_tbl_type;
1401:
1402: l_salesrep_name jtf_rs_resource_extns_vl.resource_name%TYPE;
1403: l_org_name hr_all_organization_units.name%TYPE;
1404:
1405: BEGIN
1406:
1407: --log key input parameters