DBA Data[Home] [Help]

APPS.GMD_QC_ERES_UTILS dependencies on MTL_PARAMETERS

Line 282: FROM MTL_parameters mp, hr_all_organization_units hr

278: p_orgn_name OUT NOCOPY VARCHAR2) IS
279: --RLNAGARA Bug # 4918840
280: CURSOR Cur_get_organization IS
281: SELECT hr.NAME
282: FROM MTL_parameters mp, hr_all_organization_units hr
283: WHERE mp.ORGANIZATION_CODE =p_orgn_code
284: and hr.organization_id = mp.organization_id;
285:
286:

Line 689: FROM MTL_PARAMETERS

685: p_orgn_code OUT NOCOPY VARCHAR2) IS
686: -- RLNAGARA BUG # 4918840
687: CURSOR Cur_get_organization IS
688: SELECT ORGANIZATION_CODE
689: FROM MTL_PARAMETERS
690: WHERE ORGANIZATION_ID = p_orgn_id;
691: BEGIN
692: OPEN Cur_get_organization;
693: FETCH Cur_get_organization INTO p_orgn_code;