DBA Data[Home] [Help]

APPS.QA_PARENT_CHILD_COPY_PKG dependencies on MTL_PARAMETERS

Line 244: x_orgcode mtl_parameters.organization_code%TYPE;

240: --this function gets the organization_code from an org id
241: FUNCTION get_org_code_from_orgid(p_orgid IN NUMBER)
242: RETURN VARCHAR2
243: IS
244: x_orgcode mtl_parameters.organization_code%TYPE;
245: CURSOR C IS
246: SELECT organization_code
247: FROM mtl_parameters
248: WHERE organization_id = p_orgid;

Line 247: FROM mtl_parameters

243: IS
244: x_orgcode mtl_parameters.organization_code%TYPE;
245: CURSOR C IS
246: SELECT organization_code
247: FROM mtl_parameters
248: WHERE organization_id = p_orgid;
249: BEGIN
250: OPEN C;
251: FETCH C INTO x_orgcode;