DBA Data[Home] [Help]

APPS.PAY_IN_UTILS dependencies on HR_ORGANIZATION_UNITS

Line 2026: FROM hr_organization_units

2022: IS
2023: CURSOR c_organization_name
2024: IS
2025: SELECT name
2026: FROM hr_organization_units
2027: WHERE organization_id = p_organization_id;
2028:
2029: l_org_name hr_organization_units.name%TYPE;
2030: l_procedure CONSTANT VARCHAR2(100):= g_package ||'get_organization_name';

Line 2029: l_org_name hr_organization_units.name%TYPE;

2025: SELECT name
2026: FROM hr_organization_units
2027: WHERE organization_id = p_organization_id;
2028:
2029: l_org_name hr_organization_units.name%TYPE;
2030: l_procedure CONSTANT VARCHAR2(100):= g_package ||'get_organization_name';
2031:
2032: BEGIN
2033: set_location(g_debug,'Entering : '||l_procedure,10);