APPS.PA_PACRCBDT_XMLP_PKG dependencies on HR_ORGANIZATION_UNITS
Line 176: l_name HR_ORGANIZATION_UNITS .name%TYPE;
172: END;
173: return(l_meaning);
174: end;
175: function organization_dspformula(CARRYING_OUT_ORGANIZATION_ID in number) return char is 176: l_name HR_ORGANIZATION_UNITS .name%TYPE; 177: begin
178: BEGIN
179: select ORG.name
180: INTO l_name
Line 181: from HR_ORGANIZATION_UNITS ORG
177: begin
178: BEGIN
179: select ORG.name
180: INTO l_name 181: from HR_ORGANIZATION_UNITS ORG 182: where ORG.ORGANIZATION_ID = CARRYING_OUT_ORGANIZATION_ID;
183: EXCEPTION
184: WHEN NO_DATA_FOUND THEN
185: l_name :=NULL;