DBA Data[Home] [Help]

APPS.PO_INQ_SV dependencies on HR_ALL_ORGANIZATION_UNITS

Line 997: from hr_all_organization_units_tl hout,

993: x_progress varchar2(3) := '000';
994:
995: cursor c1(x_org_id IN number) is
996: select hout.name
997: from hr_all_organization_units_tl hout,
998: hr_org_units_no_join hrou
999: where hrou.organization_id = x_org_id
1000: and hrou.organization_id = hout.organization_id
1001: and hout.language = userenv('lang');

Line 1357: l_ship_to_ou_id HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE;

1353: x_ship_to_loc_id number;
1354: x_terms_id number;
1355:
1356: --< Shared Proc FPJ Start >
1357: l_ship_to_ou_id HR_ALL_ORGANIZATION_UNITS.organization_id%TYPE;
1358: l_return_status VARCHAR2(1); -- FND_API.g_ret_sts_success
1359: --< Shared Proc FPJ End >
1360:
1361: BEGIN