APPS.GMF_UTILITIES_GRP dependencies on MTL_PARAMETERS

Line 187: CURSOR cur_org_code (cp_org_id mtl_parameters.organization_id%TYPE) IS

183: AUTHOR : Jahnavi Boppana INVCONV August 2005
184: ==========================================================*/
185: FUNCTION get_organization_code(p_organization_id IN NUMBER)
186: RETURN VARCHAR2 IS
187: CURSOR cur_org_code (cp_org_id mtl_parameters.organization_id%TYPE) IS
188: SELECT organization_code FROM mtl_parameters
189: WHERE organization_id = cp_org_id;
190:
191: l_organization_code mtl_parameters.organization_code%TYPE;

Line 188: SELECT organization_code FROM mtl_parameters

184: ==========================================================*/
185: FUNCTION get_organization_code(p_organization_id IN NUMBER)
186: RETURN VARCHAR2 IS
187: CURSOR cur_org_code (cp_org_id mtl_parameters.organization_id%TYPE) IS
188: SELECT organization_code FROM mtl_parameters
189: WHERE organization_id = cp_org_id;
190:
191: l_organization_code mtl_parameters.organization_code%TYPE;
192: BEGIN

Line 191: l_organization_code mtl_parameters.organization_code%TYPE;

187: CURSOR cur_org_code (cp_org_id mtl_parameters.organization_id%TYPE) IS
188: SELECT organization_code FROM mtl_parameters
189: WHERE organization_id = cp_org_id;
190:
191: l_organization_code mtl_parameters.organization_code%TYPE;
192: BEGIN
193:
194: OPEN cur_org_code (p_organization_id);
195: FETCH cur_org_code INTO l_organization_code;