APPS.GMO_MBR_UTIL dependencies on DUAL

Line 146: into l_org_id from dual;

142: Select substr(P_MBR_EVT_KEY,
143: to_number(instr(P_MBR_EVT_KEY,'-'))+1,
144: decode(instr(P_MBR_EVT_KEY,'-',1,2),0,length(P_MBR_EVT_KEY),
145: to_number(instr(P_MBR_EVT_KEY,'-',1,2))-to_number(instr(P_MBR_EVT_KEY,'-'))-1))
146: into l_org_id from dual;
147:
148: SELECT hou.name ORGANIZATION_NAME , mp.organization_code ORGANIZATION_CODE into X_ORG_NAME,X_ORG_CODE
149: FROM hr_all_organization_units hou, mtl_parameters mp
150: WHERE hou.organization_id = l_org_id

Line 175: into G_ORGANIZATION_ID from dual;

171: Select substr(P_MBR_EVT_KEY,
172: to_number(instr(P_MBR_EVT_KEY,'-'))+1,
173: decode(instr(P_MBR_EVT_KEY,'-',1,2),0,length(P_MBR_EVT_KEY),
174: to_number(instr(P_MBR_EVT_KEY,'-',1,2))-to_number(instr(P_MBR_EVT_KEY,'-'))-1))
175: into G_ORGANIZATION_ID from dual;
176: RETURN l_flag;
177: END SET_GLOBAL_ORGID;
178:
179: END GMO_MBR_UTIL;