DBA Data[Home] [Help]

APPS.AP_PAYMENT_UTIL_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 36: l_ou_name hr_all_organization_units.name%TYPE;

32: *==========================================================================*/
33: FUNCTION Get_OU_NAME( p_org_id IN NUMBER)
34: RETURN VARCHAR2 IS
35:
36: l_ou_name hr_all_organization_units.name%TYPE;
37:
38: BEGIN
39: SELECT name
40: INTO l_ou_name

Line 41: FROM hr_all_organization_units

37:
38: BEGIN
39: SELECT name
40: INTO l_ou_name
41: FROM hr_all_organization_units
42: WHERE organization_id = p_org_id;
43:
44: RETURN l_ou_name;
45: