APPS.PO_INQ_SV dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1051: from hr_all_organization_units_tl hout,

1047: x_progress varchar2(3) := '000';
1048:
1049: cursor c1(x_org_id IN number) is
1050: select hout.name
1051: from hr_all_organization_units_tl hout,
1052: hr_org_units_no_join hrou
1053: where hrou.organization_id = x_org_id
1054: and hrou.organization_id = hout.organization_id
1055: and hout.language = userenv('lang');

Line 1411: l_ship_to_ou_id HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE;

1407: x_ship_to_loc_id number;
1408: x_terms_id number;
1409:
1410: --< Shared Proc FPJ Start >
1411: l_ship_to_ou_id HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE;
1412: l_return_status VARCHAR2(1); -- FND_API.g_ret_sts_success
1413: --< Shared Proc FPJ End >
1414:
1415: BEGIN