DBA Data[Home] [Help]

APPS.AP_PAYMENT_UTIL_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 53: l_ou_name hr_all_organization_units.name%TYPE;

49: *==========================================================================*/
50: FUNCTION Get_OU_NAME( p_org_id IN NUMBER)
51: RETURN VARCHAR2 IS
52:
53: l_ou_name hr_all_organization_units.name%TYPE;
54:
55: BEGIN
56: SELECT name
57: INTO l_ou_name

Line 58: FROM hr_all_organization_units

54:
55: BEGIN
56: SELECT name
57: INTO l_ou_name
58: FROM hr_all_organization_units
59: WHERE organization_id = p_org_id;
60:
61: RETURN l_ou_name;
62: