APPS.GMD_CONC_REPLACE_PKG dependencies on DUAL

Line 730: FROM dual;

726: DECODE(get_object_rec.replace_type,'OWNER_ID'
727: ,get_object_rec.new_name
728: ,NULL)
729: INTO l_formula_class, l_new_ingredient, l_old_ingredient, l_owner_id
730: FROM dual;
731:
732: IF (l_debug = 'Y') THEN
733: gmd_debug.put_line
734: ('In MSNR replace : In Insert mode '

Line 947: FROM dual;

943: DECODE(get_object_rec.replace_type,'OWNER_ID'
944: ,get_object_rec.new_name
945: ,NULL)
946: INTO l_formula_id, l_routing_id, l_organization_id, l_recipe_type, l_owner_id
947: FROM dual;
948:
949: -- NPD Conv
950: IF (get_object_rec.replace_type = 'OWNER_ORGN_CODE') THEN
951:

Line 1186: FROM dual;

1182: ,get_object_rec.new_name
1183: ,NULL)
1184: INTO l_start_date, l_end_date, l_old_oprn, l_new_oprn,
1185: l_routing_class, l_owner_id
1186: FROM dual;
1187: -- Bug# 5493773 Kapil M Pass the old End date
1188: IF NOT get_object_rec.replace_type = 'END_DATE' THEN
1189: l_end_date := FND_DATE.date_to_canonical(l_old_end_date);
1190: END IF;

Line 1392: FROM dual;

1388: ,get_object_rec.new_name
1389: ,NULL)
1390: INTO l_start_date, l_end_date, l_old_actv, l_new_actv,
1391: l_oprn_class, l_old_resource, l_new_resource, l_organization_id
1392: FROM dual;
1393:
1394: IF (l_debug = 'Y') THEN
1395: gmd_debug.put_line(g_pkg_name||'.'||l_api_name
1396: ||' : About to call create_new_operation - End Date = '

Line 1970: FROM sys.dual;

1966: 'OPERATION','OPRN_ID',
1967: 'ROUTING','ROUTING_ID',
1968: 'VALIDITY','RECIPE_VALIDITY_RULE_ID')
1969: INTO l_table_name, l_primary_key
1970: FROM sys.dual;
1971:
1972: l_replace_type := pReplace_type;
1973:
1974: IF (l_debug = 'Y') THEN