APPS.PAY_IN_UTILS dependencies on HR_ORGANIZATION_UNITS

Line 2041: FROM hr_organization_units

2037: IS
2038: CURSOR c_organization_name
2039: IS
2040: SELECT name
2041: FROM hr_organization_units
2042: WHERE organization_id = p_organization_id;
2043:
2044: l_org_name hr_organization_units.name%TYPE;
2045: l_procedure CONSTANT VARCHAR2(100):= g_package ||'get_organization_name';

Line 2044: l_org_name hr_organization_units.name%TYPE;

2040: SELECT name
2041: FROM hr_organization_units
2042: WHERE organization_id = p_organization_id;
2043:
2044: l_org_name hr_organization_units.name%TYPE;
2045: l_procedure CONSTANT VARCHAR2(100):= g_package ||'get_organization_name';
2046:
2047: BEGIN
2048: set_location(g_debug,'Entering : '||l_procedure,10);