APPS.INVPVDR5 dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 8: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.name%TYPE;

4: -- created for fixing 3108469
5: function get_msg_text (p_message_name IN VARCHAR2
6: ,p_organization_id IN NUMBER)
7: RETURN VARCHAR2 IS
8: l_org_name HR_ALL_ORGANIZATION_UNITS_VL.name%TYPE;
9: l_msg_text fnd_new_messages.message_text%TYPE;
10: BEGIN
11:
12: BEGIN

Line 15: FROM hr_all_organization_units_vl

11:
12: BEGIN
13: SELECT name
14: INTO l_org_name
15: FROM hr_all_organization_units_vl
16: WHERE organization_id = p_organization_id;
17: EXCEPTION
18: WHEN OTHERS THEN
19: l_org_name := p_organization_id;