APPS.PA_BL_UTILS dependencies on HR_ALL_ORGANIZATION_UNITS_TL

Line 89: v_org_id hr_all_organization_units_tl.organization_id%TYPE;

85: v_override_orgid IN pa_expenditure_items_all.override_to_organization_id%TYPE,
86: v_incurred_by_orgid IN pa_expenditures_all.incurred_by_organization_id%TYPE)
87: RETURN VARCHAR2
88: IS
89: v_org_id hr_all_organization_units_tl.organization_id%TYPE;
90: v_org_name hr_all_organization_units_tl.name%TYPE;
91: v_error_msg VARCHAR2(25) := 'NO ORGANIZATION FOUND';
92: BEGIN
93:

Line 90: v_org_name hr_all_organization_units_tl.name%TYPE;

86: v_incurred_by_orgid IN pa_expenditures_all.incurred_by_organization_id%TYPE)
87: RETURN VARCHAR2
88: IS
89: v_org_id hr_all_organization_units_tl.organization_id%TYPE;
90: v_org_name hr_all_organization_units_tl.name%TYPE;
91: v_error_msg VARCHAR2(25) := 'NO ORGANIZATION FOUND';
92: BEGIN
93:
94: -- get the appropriate organization id

Line 104: FROM hr_all_organization_units_tl

100:
101: -- get organization name
102: SELECT name
103: INTO v_org_name
104: FROM hr_all_organization_units_tl
105: WHERE organization_id = v_org_id
106: AND decode(organization_id, null, '1', language)
107: = decode(organization_id, null, '1', userenv('lang'));
108: